malloy logo Malloy Documentation
search

Name Game

You can find the complete source code for this model here.

The Data set consists of name, gender, state and year with the number of people that were born with that name in that gender, state and year.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  top: 10
  project: *
}
QUERY RESULTS
state gender year name number
AK F 1,910 Elsie 6
AL F 1,910 Annie 482
AL F 1,910 Katie 84
AL F 1,910 Alma 82
AL F 1,910 Thelma 65
AL F 1,910 Ellen 38
AL F 1,910 Rebecca 35
AL F 1,910 Estella 21
AL F 1,910 Corine 17
AL F 1,910 Margie 17
[
  {
    "state": "AK",
    "gender": "F",
    "year": 1910,
    "name": "Elsie",
    "number": 6
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Annie",
    "number": 482
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Katie",
    "number": 84
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Alma",
    "number": 82
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Thelma",
    "number": 65
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Ellen",
    "number": 38
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Rebecca",
    "number": 35
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Estella",
    "number": 21
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Corine",
    "number": 17
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Margie",
    "number": 17
  }
]
SELECT 
   base.state as state,
   base.gender as gender,
   base.year as year,
   base.name as name,
   base.number as number
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
LIMIT 10

The command above says query the table 'bigquery-public-data.usa_names.usa_1910_2013' and project (show) all the columns for the first 10 rows.

Grouping a query

In SQL there are basically two kinds of SELECT commands: SELECT ... GROUP BY and SELECT without a grouping. In malloy, these are two different commands. The command in malloy for SELECT ... GROUP BY is group_by. Since number and year are reserved words, we have to quote the names with back-tics.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  group_by: name
  aggregate: population is `number`.sum()
}
QUERY RESULTS
name population
James 4,942,431
John 4,834,422
Robert 4,718,787
Michael 4,297,230
William 3,822,209
Mary 3,737,679
David 3,549,801
Richard 2,531,924
Joseph 2,472,917
Charles 2,244,693
Thomas 2,212,781
Christopher 1,987,490
Daniel 1,842,964
Patricia 1,569,570
Matthew 1,538,689
Elizabeth 1,492,404
Jennifer 1,463,145
Linda 1,447,601
Barbara 1,424,203
Donald 1,402,666
Anthony 1,385,453
Paul 1,355,711
Mark 1,339,371
George 1,321,652
Steven 1,269,627
Kenneth 1,259,720
Andrew 1,228,080
Edward 1,210,315
Joshua 1,163,481
Brian 1,156,495
Kevin 1,148,680
Margaret 1,120,766
Susan 1,108,712
Ronald 1,074,141
Timothy 1,055,792
Dorothy 1,052,570
Jessica 1,038,359
Jason 1,009,416
Sarah 1,006,934
Betty 985,364
Nancy 984,185
Karen 982,192
Jeffrey 969,093
Lisa 962,981
Ryan 907,969
Gary 896,637
Helen 895,428
Sandra 870,958
Nicholas 867,231
Eric 862,204
Jacob 848,518
Stephen 844,930
Ashley 841,427
Donna 826,714
Kimberly 826,275
Frank 818,197
Carol 817,290
Jonathan 803,723
Michelle 803,162
Larry 801,398
Emily 779,755
Amanda 769,292
Scott 765,844
Justin 757,273
Laura 745,892
Melissa 745,498
Raymond 744,284
Deborah 735,869
Brandon 735,849
Stephanie 732,651
Rebecca 728,799
Ruth 728,678
Anna 719,803
Sharon 718,701
Kathleen 703,265
Cynthia 703,175
Gregory 701,504
Shirley 686,079
Samuel 681,358
Amy 673,234
Benjamin 664,328
Patrick 655,434
Angela 653,663
Jack 634,113
Virginia 621,448
Jerry 618,105
Dennis 610,894
Catherine 606,029
Brenda 604,067
Alexander 598,944
Katherine 593,220
Pamela 591,307
Nicole 576,870
Tyler 576,031
Christine 574,120
Henry 571,539
Walter 558,026
Peter 553,789
Douglas 552,666
Janet 550,557
[
  {
    "name": "James",
    "population": 4942431
  },
  {
    "name": "John",
    "population": 4834422
  },
  {
    "name": "Robert",
    "population": 4718787
  },
  {
    "name": "Michael",
    "population": 4297230
  },
  {
    "name": "William",
    "population": 3822209
  },
  {
    "name": "Mary",
    "population": 3737679
  },
  {
    "name": "David",
    "population": 3549801
  },
  {
    "name": "Richard",
    "population": 2531924
  },
  {
    "name": "Joseph",
    "population": 2472917
  },
  {
    "name": "Charles",
    "population": 2244693
  },
  {
    "name": "Thomas",
    "population": 2212781
  },
  {
    "name": "Christopher",
    "population": 1987490
  },
  {
    "name": "Daniel",
    "population": 1842964
  },
  {
    "name": "Patricia",
    "population": 1569570
  },
  {
    "name": "Matthew",
    "population": 1538689
  },
  {
    "name": "Elizabeth",
    "population": 1492404
  },
  {
    "name": "Jennifer",
    "population": 1463145
  },
  {
    "name": "Linda",
    "population": 1447601
  },
  {
    "name": "Barbara",
    "population": 1424203
  },
  {
    "name": "Donald",
    "population": 1402666
  },
  {
    "name": "Anthony",
    "population": 1385453
  },
  {
    "name": "Paul",
    "population": 1355711
  },
  {
    "name": "Mark",
    "population": 1339371
  },
  {
    "name": "George",
    "population": 1321652
  },
  {
    "name": "Steven",
    "population": 1269627
  },
  {
    "name": "Kenneth",
    "population": 1259720
  },
  {
    "name": "Andrew",
    "population": 1228080
  },
  {
    "name": "Edward",
    "population": 1210315
  },
  {
    "name": "Joshua",
    "population": 1163481
  },
  {
    "name": "Brian",
    "population": 1156495
  },
  {
    "name": "Kevin",
    "population": 1148680
  },
  {
    "name": "Margaret",
    "population": 1120766
  },
  {
    "name": "Susan",
    "population": 1108712
  },
  {
    "name": "Ronald",
    "population": 1074141
  },
  {
    "name": "Timothy",
    "population": 1055792
  },
  {
    "name": "Dorothy",
    "population": 1052570
  },
  {
    "name": "Jessica",
    "population": 1038359
  },
  {
    "name": "Jason",
    "population": 1009416
  },
  {
    "name": "Sarah",
    "population": 1006934
  },
  {
    "name": "Betty",
    "population": 985364
  },
  {
    "name": "Nancy",
    "population": 984185
  },
  {
    "name": "Karen",
    "population": 982192
  },
  {
    "name": "Jeffrey",
    "population": 969093
  },
  {
    "name": "Lisa",
    "population": 962981
  },
  {
    "name": "Ryan",
    "population": 907969
  },
  {
    "name": "Gary",
    "population": 896637
  },
  {
    "name": "Helen",
    "population": 895428
  },
  {
    "name": "Sandra",
    "population": 870958
  },
  {
    "name": "Nicholas",
    "population": 867231
  },
  {
    "name": "Eric",
    "population": 862204
  },
  {
    "name": "Jacob",
    "population": 848518
  },
  {
    "name": "Stephen",
    "population": 844930
  },
  {
    "name": "Ashley",
    "population": 841427
  },
  {
    "name": "Donna",
    "population": 826714
  },
  {
    "name": "Kimberly",
    "population": 826275
  },
  {
    "name": "Frank",
    "population": 818197
  },
  {
    "name": "Carol",
    "population": 817290
  },
  {
    "name": "Jonathan",
    "population": 803723
  },
  {
    "name": "Michelle",
    "population": 803162
  },
  {
    "name": "Larry",
    "population": 801398
  },
  {
    "name": "Emily",
    "population": 779755
  },
  {
    "name": "Amanda",
    "population": 769292
  },
  {
    "name": "Scott",
    "population": 765844
  },
  {
    "name": "Justin",
    "population": 757273
  },
  {
    "name": "Laura",
    "population": 745892
  },
  {
    "name": "Melissa",
    "population": 745498
  },
  {
    "name": "Raymond",
    "population": 744284
  },
  {
    "name": "Deborah",
    "population": 735869
  },
  {
    "name": "Brandon",
    "population": 735849
  },
  {
    "name": "Stephanie",
    "population": 732651
  },
  {
    "name": "Rebecca",
    "population": 728799
  },
  {
    "name": "Ruth",
    "population": 728678
  },
  {
    "name": "Anna",
    "population": 719803
  },
  {
    "name": "Sharon",
    "population": 718701
  },
  {
    "name": "Kathleen",
    "population": 703265
  },
  {
    "name": "Cynthia",
    "population": 703175
  },
  {
    "name": "Gregory",
    "population": 701504
  },
  {
    "name": "Shirley",
    "population": 686079
  },
  {
    "name": "Samuel",
    "population": 681358
  },
  {
    "name": "Amy",
    "population": 673234
  },
  {
    "name": "Benjamin",
    "population": 664328
  },
  {
    "name": "Patrick",
    "population": 655434
  },
  {
    "name": "Angela",
    "population": 653663
  },
  {
    "name": "Jack",
    "population": 634113
  },
  {
    "name": "Virginia",
    "population": 621448
  },
  {
    "name": "Jerry",
    "population": 618105
  },
  {
    "name": "Dennis",
    "population": 610894
  },
  {
    "name": "Catherine",
    "population": 606029
  },
  {
    "name": "Brenda",
    "population": 604067
  },
  {
    "name": "Alexander",
    "population": 598944
  },
  {
    "name": "Katherine",
    "population": 593220
  },
  {
    "name": "Pamela",
    "population": 591307
  },
  {
    "name": "Nicole",
    "population": 576870
  },
  {
    "name": "Tyler",
    "population": 576031
  },
  {
    "name": "Christine",
    "population": 574120
  },
  {
    "name": "Henry",
    "population": 571539
  },
  {
    "name": "Walter",
    "population": 558026
  },
  {
    "name": "Peter",
    "population": 553789
  },
  {
    "name": "Douglas",
    "population": 552666
  },
  {
    "name": "Janet",
    "population": 550557
  }
]
SELECT 
   base.name as name,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc

malloy compiles to SQL. The SQL query for the above command is.

SELECT
   base.name as name,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc

Expressions

Expressions work much the same as they do in SQL. We can look at population over decade by using a calculation against the year.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  top: 10
  group_by: decade is floor(`year` / 10) * 10
  aggregate: population is sum(`number`)
}
QUERY RESULTS
decade population
1,950 37,545,138
1,960 35,405,002
1,990 33,309,594
2,000 33,041,629
1,980 32,349,146
1,970 29,238,092
1,940 27,776,913
1,920 21,375,400
1,930 19,782,373
1,910 13,592,350
[
  {
    "decade": 1950,
    "population": 37545138
  },
  {
    "decade": 1960,
    "population": 35405002
  },
  {
    "decade": 1990,
    "population": 33309594
  },
  {
    "decade": 2000,
    "population": 33041629
  },
  {
    "decade": 1980,
    "population": 32349146
  },
  {
    "decade": 1970,
    "population": 29238092
  },
  {
    "decade": 1940,
    "population": 27776913
  },
  {
    "decade": 1920,
    "population": 21375400
  },
  {
    "decade": 1930,
    "population": 19782373
  },
  {
    "decade": 1910,
    "population": 13592350
  }
]
SELECT 
   (floor(base.year/10))*10 as decade,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc
LIMIT 10

Cohorts

explore: names is from(
  table('bigquery-public-data.usa_names.usa_1910_2013') -> {
    group_by: [
      decade is floor(`year` / 10) * 10
      state
      gender
    ]
    aggregate: cohort_population is `number`.sum()
    nest: by_name is {
      group_by: name
      aggregate: population is `number`.sum()
    }
  }
) {
  measure: births_per_100k is floor(by_name.population.sum() / cohort_population.sum() * 100000)
  measure: total_cohort_population is cohort_population.sum()
  dimension: name is concat(by_name.name, '')
}

query: names -> {
  group_by: [
    state
    gender
  ]
  aggregate: total_cohort_population
  nest: names is {
    where: name : 'Michael' | 'Lloyd' | 'Olivia'
    group_by: name
    aggregate: population is by_name.population.sum()
    group_by: births_per_100k
  }
}
QUERY RESULTS
state gender total_​cohort_​population names
CA M 15,011,405
name population births_​per_​100k
Michael 420,127 2,798
Lloyd 8,380 55
CA F 13,799,158
name population births_​per_​100k
Olivia 33,794 244
Michael 2,428 19
NY M 12,203,961
name population births_​per_​100k
Michael 430,732 3,529
Lloyd 7,568 62
Olivia 5 0
NY F 11,490,175
name population births_​per_​100k
Olivia 23,219 202
Michael 1,761 16
TX M 11,126,246
name population births_​per_​100k
Michael 223,900 2,012
Lloyd 8,461 76
Olivia 6 1
TX F 10,341,113
name population births_​per_​100k
Olivia 25,746 248
Michael 1,420 16
Lloyd 15 1
PA M 8,497,961
name population births_​per_​100k
Michael 266,380 3,134
Lloyd 7,874 92
Olivia 22 2
PA F 8,163,949
name population births_​per_​100k
Olivia 16,292 199
Michael 910 11
IL M 7,845,252
name population births_​per_​100k
Michael 251,741 3,208
Lloyd 7,207 91
IL F 7,333,624
name population births_​per_​100k
Olivia 16,450 224
Michael 989 17
OH M 7,324,810
name population births_​per_​100k
Michael 225,302 3,075
Lloyd 6,755 92
OH F 6,876,716
name population births_​per_​100k
Olivia 16,787 244
Michael 969 18
MI M 6,036,661
name population births_​per_​100k
Michael 194,851 3,227
Lloyd 6,130 101
MI F 5,606,794
name population births_​per_​100k
Olivia 13,575 242
Michael 755 17
FL M 4,910,950
name population births_​per_​100k
Michael 138,882 2,828
Lloyd 2,876 58
FL F 4,366,273
name population births_​per_​100k
Olivia 15,208 348
Michael 691 18
NC M 4,326,810
name population births_​per_​100k
Michael 92,414 2,135
Lloyd 4,367 100
NJ M 4,315,822
name population births_​per_​100k
Michael 165,385 3,832
Lloyd 1,720 41
GA M 4,214,825
name population births_​per_​100k
Michael 87,684 2,080
Lloyd 2,508 59
NC F 4,113,425
name population births_​per_​100k
Olivia 10,671 259
Michael 416 19
[
  {
    "state": "CA",
    "gender": "M",
    "total_cohort_population": 15011405,
    "names": [
      {
        "name": "Michael",
        "population": 420127,
        "births_per_100k": 2798
      },
      {
        "name": "Lloyd",
        "population": 8380,
        "births_per_100k": 55
      }
    ]
  },
  {
    "state": "CA",
    "gender": "F",
    "total_cohort_population": 13799158,
    "names": [
      {
        "name": "Olivia",
        "population": 33794,
        "births_per_100k": 244
      },
      {
        "name": "Michael",
        "population": 2428,
        "births_per_100k": 19
      }
    ]
  },
  {
    "state": "NY",
    "gender": "M",
    "total_cohort_population": 12203961,
    "names": [
      {
        "name": "Michael",
        "population": 430732,
        "births_per_100k": 3529
      },
      {
        "name": "Lloyd",
        "population": 7568,
        "births_per_100k": 62
      },
      {
        "name": "Olivia",
        "population": 5,
        "births_per_100k": 0
      }
    ]
  },
  {
    "state": "NY",
    "gender": "F",
    "total_cohort_population": 11490175,
    "names": [
      {
        "name": "Olivia",
        "population": 23219,
        "births_per_100k": 202
      },
      {
        "name": "Michael",
        "population": 1761,
        "births_per_100k": 16
      }
    ]
  },
  {
    "state": "TX",
    "gender": "M",
    "total_cohort_population": 11126246,
    "names": [
      {
        "name": "Michael",
        "population": 223900,
        "births_per_100k": 2012
      },
      {
        "name": "Lloyd",
        "population": 8461,
        "births_per_100k": 76
      },
      {
        "name": "Olivia",
        "population": 6,
        "births_per_100k": 1
      }
    ]
  },
  {
    "state": "TX",
    "gender": "F",
    "total_cohort_population": 10341113,
    "names": [
      {
        "name": "Olivia",
        "population": 25746,
        "births_per_100k": 248
      },
      {
        "name": "Michael",
        "population": 1420,
        "births_per_100k": 16
      },
      {
        "name": "Lloyd",
        "population": 15,
        "births_per_100k": 1
      }
    ]
  },
  {
    "state": "PA",
    "gender": "M",
    "total_cohort_population": 8497961,
    "names": [
      {
        "name": "Michael",
        "population": 266380,
        "births_per_100k": 3134
      },
      {
        "name": "Lloyd",
        "population": 7874,
        "births_per_100k": 92
      },
      {
        "name": "Olivia",
        "population": 22,
        "births_per_100k": 2
      }
    ]
  },
  {
    "state": "PA",
    "gender": "F",
    "total_cohort_population": 8163949,
    "names": [
      {
        "name": "Olivia",
        "population": 16292,
        "births_per_100k": 199
      },
      {
        "name": "Michael",
        "population": 910,
        "births_per_100k": 11
      }
    ]
  },
  {
    "state": "IL",
    "gender": "M",
    "total_cohort_population": 7845252,
    "names": [
      {
        "name": "Michael",
        "population": 251741,
        "births_per_100k": 3208
      },
      {
        "name": "Lloyd",
        "population": 7207,
        "births_per_100k": 91
      }
    ]
  },
  {
    "state": "IL",
    "gender": "F",
    "total_cohort_population": 7333624,
    "names": [
      {
        "name": "Olivia",
        "population": 16450,
        "births_per_100k": 224
      },
      {
        "name": "Michael",
        "population": 989,
        "births_per_100k": 17
      }
    ]
  },
  {
    "state": "OH",
    "gender": "M",
    "total_cohort_population": 7324810,
    "names": [
      {
        "name": "Michael",
        "population": 225302,
        "births_per_100k": 3075
      },
      {
        "name": "Lloyd",
        "population": 6755,
        "births_per_100k": 92
      }
    ]
  },
  {
    "state": "OH",
    "gender": "F",
    "total_cohort_population": 6876716,
    "names": [
      {
        "name": "Olivia",
        "population": 16787,
        "births_per_100k": 244
      },
      {
        "name": "Michael",
        "population": 969,
        "births_per_100k": 18
      }
    ]
  },
  {
    "state": "MI",
    "gender": "M",
    "total_cohort_population": 6036661,
    "names": [
      {
        "name": "Michael",
        "population": 194851,
        "births_per_100k": 3227
      },
      {
        "name": "Lloyd",
        "population": 6130,
        "births_per_100k": 101
      }
    ]
  },
  {
    "state": "MI",
    "gender": "F",
    "total_cohort_population": 5606794,
    "names": [
      {
        "name": "Olivia",
        "population": 13575,
        "births_per_100k": 242
      },
      {
        "name": "Michael",
        "population": 755,
        "births_per_100k": 17
      }
    ]
  },
  {
    "state": "FL",
    "gender": "M",
    "total_cohort_population": 4910950,
    "names": [
      {
        "name": "Michael",
        "population": 138882,
        "births_per_100k": 2828
      },
      {
        "name": "Lloyd",
        "population": 2876,
        "births_per_100k": 58
      }
    ]
  },
  {
    "state": "FL",
    "gender": "F",
    "total_cohort_population": 4366273,
    "names": [
      {
        "name": "Olivia",
        "population": 15208,
        "births_per_100k": 348
      },
      {
        "name": "Michael",
        "population": 691,
        "births_per_100k": 18
      }
    ]
  },
  {
    "state": "NC",
    "gender": "M",
    "total_cohort_population": 4326810,
    "names": [
      {
        "name": "Michael",
        "population": 92414,
        "births_per_100k": 2135
      },
      {
        "name": "Lloyd",
        "population": 4367,
        "births_per_100k": 100
      }
    ]
  },
  {
    "state": "NJ",
    "gender": "M",
    "total_cohort_population": 4315822,
    "names": [
      {
        "name": "Michael",
        "population": 165385,
        "births_per_100k": 3832
      },
      {
        "name": "Lloyd",
        "population": 1720,
        "births_per_100k": 41
      }
    ]
  },
  {
    "state": "GA",
    "gender": "M",
    "total_cohort_population": 4214825,
    "names": [
      {
        "name": "Michael",
        "population": 87684,
        "births_per_100k": 2080
      },
      {
        "name": "Lloyd",
        "population": 2508,
        "births_per_100k": 59
      }
    ]
  },
  {
    "state": "NC",
    "gender": "F",
    "total_cohort_population": 4113425,
    "names": [
      {
        "name": "Olivia",
        "population": 10671,
        "births_per_100k": 259
      },
      {
        "name": "Michael",
        "population": 416,
        "births_per_100k": 19
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN SUM(base.number) END as cohort_population__0,
    CASE WHEN group_set=1 THEN base.name END as name__1,
    CASE WHEN group_set=1 THEN SUM(base.number) END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,6
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(name__1 as name, population__1 as population) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3
  ORDER BY 4 desc
)
, __stage2 AS (
  SELECT
    group_set,
    names.state as state__0,
    names.gender as gender__0,
    CASE WHEN group_set=0 THEN CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64) END as total_cohort_population__0,
    CASE WHEN group_set=1 THEN concat(by_name_0.name,'') END as name__1,
    CASE WHEN group_set=1 THEN SUM(by_name_0.population) END as population__1,
    CASE WHEN group_set=1 THEN floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__1
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1) as names
  , UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  WHERE (group_set NOT IN (1) OR (group_set IN (1) AND (concat(by_name_0.name,'')='Michael')or((concat(by_name_0.name,'')='Lloyd')or(concat(by_name_0.name,'')='Olivia'))))
  GROUP BY 1,2,3,5
)
SELECT
  state__0 as state,
  gender__0 as gender,
  ANY_VALUE(CASE WHEN group_set=0 THEN total_cohort_population__0 END) as total_cohort_population,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(name__1 as name, population__1 as population, births_per_100k__1 as births_per_100k) END IGNORE NULLS  ORDER BY  population__1 desc ) as names
FROM __stage2
GROUP BY 1,2
ORDER BY 3 desc

Dashboard

query: names -> name_dashboard { where: name ~ 'Mich%' }
QUERY RESULTS
name total_​population state_​map decade_​graph
Michael 4,387,274 1,5002,0002,5003,0003,500births_per_100k 1,9201,9401,9601,9802,0002,020decade02,0004,000births_per_100kFemaleMalebaby_gender
Michelle 812,865 4006008001,000births_per_100k 1,9201,9401,9601,9802,0002,020decade05001,0001,5002,000births_per_100kFemaleMalebaby_gender
Michele 221,803 100200300400births_per_100k 1,9201,9401,9601,9802,0002,020decade0200400births_per_100kFemaleMalebaby_gender
Micheal 150,850 50100150200births_per_100k 1,9201,9401,9601,9802,0002,020decade0100200births_per_100kFemaleMalebaby_gender
Michaela 48,407 50100150200births_per_100k 1,9401,9601,9802,0002,020decade050100150births_per_100kFemaleMalebaby_gender
Michel 7,056 10203040births_per_100k 1,9201,9401,9601,9802,000decade02468births_per_100kFemaleMalebaby_gender
Michell 4,377 5101520births_per_100k 1,9601,9802,000decade0510births_per_100kFemaleMalebaby_gender
Michal 2,371 02468births_per_100k 1,9401,9601,9802,0002,020decade01020births_per_100kFemaleMalebaby_gender
Michale 958 1234births_per_100k 1,9601,9802,000decade0123births_per_100kMalebaby_gender
Michelina 903 02468births_per_100k 1,9201,9401,9601,9802,000decade0510births_per_100kFemalebaby_gender
Michaella 705 123456births_per_100k 1,9601,9701,9801,9902,0002,010decade01234births_per_100kFemalebaby_gender
Michela 616 24681012births_per_100k 1,9401,9601,9802,000decade024births_per_100kFemalebaby_gender
Michaelangelo 574 0123births_per_100k 1,9701,9801,9902,0002,0102,020decade0123births_per_100kMalebaby_gender
Michaelene 477 01234births_per_100k 1,9301,9401,9501,9601,9701,980decade01234births_per_100kFemalebaby_gender
Michala 465 02468births_per_100k 1,9701,9801,9902,000decade024births_per_100kFemalebaby_gender
[
  {
    "name": "Michael",
    "total_population": 4387274,
    "state_map": [
      {
        "state": "RI",
        "births_per_100k": 3702
      },
      {
        "state": "AK",
        "births_per_100k": 3331
      },
      {
        "state": "DE",
        "births_per_100k": 3328
      },
      {
        "state": "VT",
        "births_per_100k": 3049
      },
      {
        "state": "NH",
        "births_per_100k": 2813
      },
      {
        "state": "ME",
        "births_per_100k": 2804
      },
      {
        "state": "WY",
        "births_per_100k": 2667
      },
      {
        "state": "HI",
        "births_per_100k": 2529
      },
      {
        "state": "CT",
        "births_per_100k": 2489
      },
      {
        "state": "NV",
        "births_per_100k": 2443
      },
      {
        "state": "DC",
        "births_per_100k": 2347
      },
      {
        "state": "MT",
        "births_per_100k": 2292
      },
      {
        "state": "MA",
        "births_per_100k": 2240
      },
      {
        "state": "NJ",
        "births_per_100k": 2232
      },
      {
        "state": "SD",
        "births_per_100k": 2228
      },
      {
        "state": "ND",
        "births_per_100k": 1975
      },
      {
        "state": "MD",
        "births_per_100k": 1967
      },
      {
        "state": "ID",
        "births_per_100k": 1964
      },
      {
        "state": "WI",
        "births_per_100k": 1918
      },
      {
        "state": "NE",
        "births_per_100k": 1917
      },
      {
        "state": "OR",
        "births_per_100k": 1873
      },
      {
        "state": "IL",
        "births_per_100k": 1854
      },
      {
        "state": "MI",
        "births_per_100k": 1837
      },
      {
        "state": "NY",
        "births_per_100k": 1817
      },
      {
        "state": "WV",
        "births_per_100k": 1796
      },
      {
        "state": "IA",
        "births_per_100k": 1772
      },
      {
        "state": "OH",
        "births_per_100k": 1763
      },
      {
        "state": "CO",
        "births_per_100k": 1747
      },
      {
        "state": "NM",
        "births_per_100k": 1733
      },
      {
        "state": "MN",
        "births_per_100k": 1701
      },
      {
        "state": "IN",
        "births_per_100k": 1690
      },
      {
        "state": "WA",
        "births_per_100k": 1680
      },
      {
        "state": "MO",
        "births_per_100k": 1659
      },
      {
        "state": "VA",
        "births_per_100k": 1657
      },
      {
        "state": "UT",
        "births_per_100k": 1611
      },
      {
        "state": "AZ",
        "births_per_100k": 1610
      },
      {
        "state": "PA",
        "births_per_100k": 1609
      },
      {
        "state": "KS",
        "births_per_100k": 1604
      },
      {
        "state": "FL",
        "births_per_100k": 1564
      },
      {
        "state": "OK",
        "births_per_100k": 1545
      },
      {
        "state": "LA",
        "births_per_100k": 1433
      },
      {
        "state": "NC",
        "births_per_100k": 1405
      },
      {
        "state": "CA",
        "births_per_100k": 1398
      },
      {
        "state": "AR",
        "births_per_100k": 1385
      },
      {
        "state": "TN",
        "births_per_100k": 1370
      },
      {
        "state": "SC",
        "births_per_100k": 1367
      },
      {
        "state": "KY",
        "births_per_100k": 1348
      },
      {
        "state": "AL",
        "births_per_100k": 1244
      },
      {
        "state": "MS",
        "births_per_100k": 1214
      },
      {
        "state": "GA",
        "births_per_100k": 1144
      },
      {
        "state": "TX",
        "births_per_100k": 1028
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 4562,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 4510,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 4301,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 3848,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 2587,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 2367,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 1409,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 883,
        "baby_gender": "Male"
      },
      {
        "decade": 2020,
        "births_per_100k": 661,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 564,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 501,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 366,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 35,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 32,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 19,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1920,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michelle",
    "total_population": 812865,
    "state_map": [
      {
        "state": "VT",
        "births_per_100k": 1137
      },
      {
        "state": "AK",
        "births_per_100k": 1018
      },
      {
        "state": "HI",
        "births_per_100k": 992
      },
      {
        "state": "WY",
        "births_per_100k": 992
      },
      {
        "state": "DE",
        "births_per_100k": 920
      },
      {
        "state": "RI",
        "births_per_100k": 909
      },
      {
        "state": "ME",
        "births_per_100k": 889
      },
      {
        "state": "NH",
        "births_per_100k": 878
      },
      {
        "state": "NE",
        "births_per_100k": 848
      },
      {
        "state": "SD",
        "births_per_100k": 834
      },
      {
        "state": "ND",
        "births_per_100k": 826
      },
      {
        "state": "NM",
        "births_per_100k": 784
      },
      {
        "state": "CO",
        "births_per_100k": 772
      },
      {
        "state": "NV",
        "births_per_100k": 771
      },
      {
        "state": "MT",
        "births_per_100k": 768
      },
      {
        "state": "IA",
        "births_per_100k": 761
      },
      {
        "state": "KS",
        "births_per_100k": 754
      },
      {
        "state": "CT",
        "births_per_100k": 752
      },
      {
        "state": "OR",
        "births_per_100k": 744
      },
      {
        "state": "UT",
        "births_per_100k": 731
      },
      {
        "state": "DC",
        "births_per_100k": 725
      },
      {
        "state": "WA",
        "births_per_100k": 713
      },
      {
        "state": "ID",
        "births_per_100k": 695
      },
      {
        "state": "AZ",
        "births_per_100k": 694
      },
      {
        "state": "MO",
        "births_per_100k": 665
      },
      {
        "state": "MA",
        "births_per_100k": 652
      },
      {
        "state": "IN",
        "births_per_100k": 611
      },
      {
        "state": "MN",
        "births_per_100k": 593
      },
      {
        "state": "MD",
        "births_per_100k": 583
      },
      {
        "state": "MI",
        "births_per_100k": 563
      },
      {
        "state": "WI",
        "births_per_100k": 531
      },
      {
        "state": "OH",
        "births_per_100k": 524
      },
      {
        "state": "OK",
        "births_per_100k": 507
      },
      {
        "state": "NJ",
        "births_per_100k": 504
      },
      {
        "state": "LA",
        "births_per_100k": 502
      },
      {
        "state": "VA",
        "births_per_100k": 490
      },
      {
        "state": "IL",
        "births_per_100k": 468
      },
      {
        "state": "FL",
        "births_per_100k": 463
      },
      {
        "state": "PA",
        "births_per_100k": 458
      },
      {
        "state": "CA",
        "births_per_100k": 449
      },
      {
        "state": "WV",
        "births_per_100k": 437
      },
      {
        "state": "AR",
        "births_per_100k": 425
      },
      {
        "state": "NY",
        "births_per_100k": 416
      },
      {
        "state": "SC",
        "births_per_100k": 406
      },
      {
        "state": "KY",
        "births_per_100k": 365
      },
      {
        "state": "TN",
        "births_per_100k": 327
      },
      {
        "state": "GA",
        "births_per_100k": 318
      },
      {
        "state": "TX",
        "births_per_100k": 310
      },
      {
        "state": "MS",
        "births_per_100k": 298
      },
      {
        "state": "NC",
        "births_per_100k": 285
      },
      {
        "state": "AL",
        "births_per_100k": 281
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 1814,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1230,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1018,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 559,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 283,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 258,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 120,
        "baby_gender": "Female"
      },
      {
        "decade": 2020,
        "births_per_100k": 74,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 40,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michele",
    "total_population": 221803,
    "state_map": [
      {
        "state": "DE",
        "births_per_100k": 472
      },
      {
        "state": "CT",
        "births_per_100k": 448
      },
      {
        "state": "HI",
        "births_per_100k": 368
      },
      {
        "state": "VT",
        "births_per_100k": 351
      },
      {
        "state": "MD",
        "births_per_100k": 325
      },
      {
        "state": "RI",
        "births_per_100k": 313
      },
      {
        "state": "DC",
        "births_per_100k": 294
      },
      {
        "state": "AK",
        "births_per_100k": 287
      },
      {
        "state": "NH",
        "births_per_100k": 276
      },
      {
        "state": "NJ",
        "births_per_100k": 274
      },
      {
        "state": "SD",
        "births_per_100k": 265
      },
      {
        "state": "NV",
        "births_per_100k": 256
      },
      {
        "state": "MT",
        "births_per_100k": 245
      },
      {
        "state": "WI",
        "births_per_100k": 234
      },
      {
        "state": "ME",
        "births_per_100k": 232
      },
      {
        "state": "IA",
        "births_per_100k": 224
      },
      {
        "state": "NE",
        "births_per_100k": 224
      },
      {
        "state": "WY",
        "births_per_100k": 217
      },
      {
        "state": "ND",
        "births_per_100k": 216
      },
      {
        "state": "PA",
        "births_per_100k": 209
      },
      {
        "state": "MN",
        "births_per_100k": 208
      },
      {
        "state": "UT",
        "births_per_100k": 200
      },
      {
        "state": "MI",
        "births_per_100k": 199
      },
      {
        "state": "IN",
        "births_per_100k": 195
      },
      {
        "state": "OR",
        "births_per_100k": 187
      },
      {
        "state": "MO",
        "births_per_100k": 186
      },
      {
        "state": "MA",
        "births_per_100k": 184
      },
      {
        "state": "WA",
        "births_per_100k": 176
      },
      {
        "state": "ID",
        "births_per_100k": 175
      },
      {
        "state": "OH",
        "births_per_100k": 171
      },
      {
        "state": "KS",
        "births_per_100k": 171
      },
      {
        "state": "CO",
        "births_per_100k": 163
      },
      {
        "state": "NY",
        "births_per_100k": 154
      },
      {
        "state": "WV",
        "births_per_100k": 148
      },
      {
        "state": "IL",
        "births_per_100k": 139
      },
      {
        "state": "NM",
        "births_per_100k": 136
      },
      {
        "state": "VA",
        "births_per_100k": 132
      },
      {
        "state": "AZ",
        "births_per_100k": 116
      },
      {
        "state": "KY",
        "births_per_100k": 112
      },
      {
        "state": "LA",
        "births_per_100k": 112
      },
      {
        "state": "OK",
        "births_per_100k": 106
      },
      {
        "state": "FL",
        "births_per_100k": 99
      },
      {
        "state": "CA",
        "births_per_100k": 95
      },
      {
        "state": "AR",
        "births_per_100k": 87
      },
      {
        "state": "SC",
        "births_per_100k": 73
      },
      {
        "state": "AL",
        "births_per_100k": 68
      },
      {
        "state": "GA",
        "births_per_100k": 64
      },
      {
        "state": "TX",
        "births_per_100k": 57
      },
      {
        "state": "NC",
        "births_per_100k": 55
      },
      {
        "state": "MS",
        "births_per_100k": 51
      },
      {
        "state": "TN",
        "births_per_100k": 47
      }
    ],
    "decade_graph": [
      {
        "decade": 1960,
        "births_per_100k": 513,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 411,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 231,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 113,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 84,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 36,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 2020,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 7,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Micheal",
    "total_population": 150850,
    "state_map": [
      {
        "state": "MS",
        "births_per_100k": 222
      },
      {
        "state": "SD",
        "births_per_100k": 179
      },
      {
        "state": "SC",
        "births_per_100k": 176
      },
      {
        "state": "AR",
        "births_per_100k": 174
      },
      {
        "state": "LA",
        "births_per_100k": 171
      },
      {
        "state": "AL",
        "births_per_100k": 168
      },
      {
        "state": "MT",
        "births_per_100k": 163
      },
      {
        "state": "TN",
        "births_per_100k": 162
      },
      {
        "state": "OK",
        "births_per_100k": 160
      },
      {
        "state": "WY",
        "births_per_100k": 155
      },
      {
        "state": "IA",
        "births_per_100k": 149
      },
      {
        "state": "ID",
        "births_per_100k": 144
      },
      {
        "state": "NC",
        "births_per_100k": 143
      },
      {
        "state": "NM",
        "births_per_100k": 140
      },
      {
        "state": "DC",
        "births_per_100k": 139
      },
      {
        "state": "ND",
        "births_per_100k": 138
      },
      {
        "state": "AK",
        "births_per_100k": 135
      },
      {
        "state": "OR",
        "births_per_100k": 132
      },
      {
        "state": "NE",
        "births_per_100k": 131
      },
      {
        "state": "KY",
        "births_per_100k": 131
      },
      {
        "state": "WV",
        "births_per_100k": 127
      },
      {
        "state": "MO",
        "births_per_100k": 126
      },
      {
        "state": "KS",
        "births_per_100k": 125
      },
      {
        "state": "GA",
        "births_per_100k": 122
      },
      {
        "state": "WA",
        "births_per_100k": 120
      },
      {
        "state": "IN",
        "births_per_100k": 109
      },
      {
        "state": "MI",
        "births_per_100k": 106
      },
      {
        "state": "CO",
        "births_per_100k": 102
      },
      {
        "state": "VA",
        "births_per_100k": 101
      },
      {
        "state": "NV",
        "births_per_100k": 96
      },
      {
        "state": "UT",
        "births_per_100k": 89
      },
      {
        "state": "MD",
        "births_per_100k": 89
      },
      {
        "state": "MN",
        "births_per_100k": 87
      },
      {
        "state": "AZ",
        "births_per_100k": 85
      },
      {
        "state": "FL",
        "births_per_100k": 85
      },
      {
        "state": "WI",
        "births_per_100k": 82
      },
      {
        "state": "ME",
        "births_per_100k": 81
      },
      {
        "state": "IL",
        "births_per_100k": 81
      },
      {
        "state": "VT",
        "births_per_100k": 80
      },
      {
        "state": "OH",
        "births_per_100k": 79
      },
      {
        "state": "TX",
        "births_per_100k": 71
      },
      {
        "state": "NH",
        "births_per_100k": 63
      },
      {
        "state": "DE",
        "births_per_100k": 60
      },
      {
        "state": "CA",
        "births_per_100k": 48
      },
      {
        "state": "PA",
        "births_per_100k": 47
      },
      {
        "state": "CT",
        "births_per_100k": 43
      },
      {
        "state": "NY",
        "births_per_100k": 42
      },
      {
        "state": "RI",
        "births_per_100k": 42
      },
      {
        "state": "NJ",
        "births_per_100k": 41
      },
      {
        "state": "MA",
        "births_per_100k": 38
      },
      {
        "state": "HI",
        "births_per_100k": 32
      }
    ],
    "decade_graph": [
      {
        "decade": 1950,
        "births_per_100k": 209,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 172,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 152,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 108,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 73,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 71,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 39,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 32,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 17,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 16,
        "baby_gender": "Male"
      },
      {
        "decade": 2020,
        "births_per_100k": 13,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 12,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaela",
    "total_population": 48407,
    "state_map": [
      {
        "state": "VT",
        "births_per_100k": 229
      },
      {
        "state": "RI",
        "births_per_100k": 209
      },
      {
        "state": "SD",
        "births_per_100k": 178
      },
      {
        "state": "ME",
        "births_per_100k": 162
      },
      {
        "state": "MT",
        "births_per_100k": 160
      },
      {
        "state": "NE",
        "births_per_100k": 148
      },
      {
        "state": "AK",
        "births_per_100k": 115
      },
      {
        "state": "NH",
        "births_per_100k": 115
      },
      {
        "state": "WY",
        "births_per_100k": 110
      },
      {
        "state": "ND",
        "births_per_100k": 102
      },
      {
        "state": "CT",
        "births_per_100k": 96
      },
      {
        "state": "SC",
        "births_per_100k": 94
      },
      {
        "state": "KS",
        "births_per_100k": 94
      },
      {
        "state": "MS",
        "births_per_100k": 93
      },
      {
        "state": "HI",
        "births_per_100k": 92
      },
      {
        "state": "NM",
        "births_per_100k": 91
      },
      {
        "state": "DE",
        "births_per_100k": 89
      },
      {
        "state": "KY",
        "births_per_100k": 89
      },
      {
        "state": "MD",
        "births_per_100k": 86
      },
      {
        "state": "MA",
        "births_per_100k": 84
      },
      {
        "state": "TN",
        "births_per_100k": 83
      },
      {
        "state": "MN",
        "births_per_100k": 82
      },
      {
        "state": "WV",
        "births_per_100k": 79
      },
      {
        "state": "AR",
        "births_per_100k": 78
      },
      {
        "state": "WI",
        "births_per_100k": 77
      },
      {
        "state": "WA",
        "births_per_100k": 73
      },
      {
        "state": "NC",
        "births_per_100k": 73
      },
      {
        "state": "OK",
        "births_per_100k": 73
      },
      {
        "state": "OR",
        "births_per_100k": 73
      },
      {
        "state": "VA",
        "births_per_100k": 71
      },
      {
        "state": "IN",
        "births_per_100k": 70
      },
      {
        "state": "ID",
        "births_per_100k": 68
      },
      {
        "state": "AL",
        "births_per_100k": 68
      },
      {
        "state": "MO",
        "births_per_100k": 67
      },
      {
        "state": "IA",
        "births_per_100k": 65
      },
      {
        "state": "CO",
        "births_per_100k": 64
      },
      {
        "state": "AZ",
        "births_per_100k": 62
      },
      {
        "state": "GA",
        "births_per_100k": 60
      },
      {
        "state": "NV",
        "births_per_100k": 60
      },
      {
        "state": "UT",
        "births_per_100k": 60
      },
      {
        "state": "DC",
        "births_per_100k": 55
      },
      {
        "state": "FL",
        "births_per_100k": 49
      },
      {
        "state": "LA",
        "births_per_100k": 48
      },
      {
        "state": "PA",
        "births_per_100k": 47
      },
      {
        "state": "NJ",
        "births_per_100k": 43
      },
      {
        "state": "OH",
        "births_per_100k": 43
      },
      {
        "state": "IL",
        "births_per_100k": 40
      },
      {
        "state": "MI",
        "births_per_100k": 40
      },
      {
        "state": "TX",
        "births_per_100k": 37
      },
      {
        "state": "NY",
        "births_per_100k": 36
      },
      {
        "state": "CA",
        "births_per_100k": 28
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 149,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 84,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 45,
        "baby_gender": "Female"
      },
      {
        "decade": 2020,
        "births_per_100k": 37,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 27,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michel",
    "total_population": 7056,
    "state_map": [
      {
        "state": "NH",
        "births_per_100k": 46
      },
      {
        "state": "ME",
        "births_per_100k": 30
      },
      {
        "state": "VT",
        "births_per_100k": 12
      },
      {
        "state": "LA",
        "births_per_100k": 11
      },
      {
        "state": "MS",
        "births_per_100k": 8
      },
      {
        "state": "MA",
        "births_per_100k": 8
      },
      {
        "state": "MO",
        "births_per_100k": 7
      },
      {
        "state": "IN",
        "births_per_100k": 7
      },
      {
        "state": "AR",
        "births_per_100k": 7
      },
      {
        "state": "OK",
        "births_per_100k": 7
      },
      {
        "state": "IA",
        "births_per_100k": 6
      },
      {
        "state": "FL",
        "births_per_100k": 6
      },
      {
        "state": "ID",
        "births_per_100k": 6
      },
      {
        "state": "NY",
        "births_per_100k": 5
      },
      {
        "state": "CA",
        "births_per_100k": 5
      },
      {
        "state": "TN",
        "births_per_100k": 5
      },
      {
        "state": "KY",
        "births_per_100k": 5
      },
      {
        "state": "CO",
        "births_per_100k": 5
      },
      {
        "state": "WA",
        "births_per_100k": 5
      },
      {
        "state": "MI",
        "births_per_100k": 4
      },
      {
        "state": "OH",
        "births_per_100k": 4
      },
      {
        "state": "OR",
        "births_per_100k": 4
      },
      {
        "state": "VA",
        "births_per_100k": 4
      },
      {
        "state": "SC",
        "births_per_100k": 4
      },
      {
        "state": "TX",
        "births_per_100k": 4
      },
      {
        "state": "GA",
        "births_per_100k": 4
      },
      {
        "state": "IL",
        "births_per_100k": 3
      },
      {
        "state": "KS",
        "births_per_100k": 3
      },
      {
        "state": "AL",
        "births_per_100k": 3
      },
      {
        "state": "NC",
        "births_per_100k": 3
      },
      {
        "state": "CT",
        "births_per_100k": 3
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "MN",
        "births_per_100k": 2
      },
      {
        "state": "WI",
        "births_per_100k": 2
      },
      {
        "state": "NJ",
        "births_per_100k": 2
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1950,
        "births_per_100k": 9,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 8,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 6,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 6,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1920,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michell",
    "total_population": 4377,
    "state_map": [
      {
        "state": "MS",
        "births_per_100k": 21
      },
      {
        "state": "LA",
        "births_per_100k": 16
      },
      {
        "state": "MO",
        "births_per_100k": 14
      },
      {
        "state": "AR",
        "births_per_100k": 13
      },
      {
        "state": "NV",
        "births_per_100k": 10
      },
      {
        "state": "CO",
        "births_per_100k": 10
      },
      {
        "state": "OK",
        "births_per_100k": 9
      },
      {
        "state": "KS",
        "births_per_100k": 9
      },
      {
        "state": "IN",
        "births_per_100k": 9
      },
      {
        "state": "GA",
        "births_per_100k": 9
      },
      {
        "state": "KY",
        "births_per_100k": 9
      },
      {
        "state": "AL",
        "births_per_100k": 9
      },
      {
        "state": "DC",
        "births_per_100k": 8
      },
      {
        "state": "SC",
        "births_per_100k": 8
      },
      {
        "state": "AZ",
        "births_per_100k": 7
      },
      {
        "state": "CA",
        "births_per_100k": 6
      },
      {
        "state": "OH",
        "births_per_100k": 6
      },
      {
        "state": "TX",
        "births_per_100k": 6
      },
      {
        "state": "FL",
        "births_per_100k": 6
      },
      {
        "state": "WA",
        "births_per_100k": 6
      },
      {
        "state": "NY",
        "births_per_100k": 5
      },
      {
        "state": "IL",
        "births_per_100k": 5
      },
      {
        "state": "MI",
        "births_per_100k": 5
      },
      {
        "state": "MD",
        "births_per_100k": 5
      },
      {
        "state": "NJ",
        "births_per_100k": 4
      },
      {
        "state": "WI",
        "births_per_100k": 4
      },
      {
        "state": "PA",
        "births_per_100k": 4
      },
      {
        "state": "NC",
        "births_per_100k": 4
      },
      {
        "state": "MN",
        "births_per_100k": 3
      },
      {
        "state": "TN",
        "births_per_100k": 3
      },
      {
        "state": "OR",
        "births_per_100k": 3
      },
      {
        "state": "MA",
        "births_per_100k": 2
      },
      {
        "state": "VA",
        "births_per_100k": 2
      },
      {
        "state": "IA",
        "births_per_100k": 2
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 13,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 7,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 6,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 6,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michal",
    "total_population": 2371,
    "state_map": [
      {
        "state": "UT",
        "births_per_100k": 8
      },
      {
        "state": "IL",
        "births_per_100k": 8
      },
      {
        "state": "NJ",
        "births_per_100k": 6
      },
      {
        "state": "NY",
        "births_per_100k": 5
      },
      {
        "state": "CT",
        "births_per_100k": 5
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "IA",
        "births_per_100k": 2
      },
      {
        "state": "CO",
        "births_per_100k": 2
      },
      {
        "state": "CA",
        "births_per_100k": 1
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "TX",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "MO",
        "births_per_100k": 1
      },
      {
        "state": "MA",
        "births_per_100k": 1
      },
      {
        "state": "TN",
        "births_per_100k": 1
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "AL",
        "births_per_100k": 1
      },
      {
        "state": "MI",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 2020,
        "births_per_100k": 22,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 6,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michale",
    "total_population": 958,
    "state_map": [
      {
        "state": "UT",
        "births_per_100k": 4
      },
      {
        "state": "CA",
        "births_per_100k": 3
      },
      {
        "state": "FL",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "TX",
        "births_per_100k": 2
      },
      {
        "state": "OK",
        "births_per_100k": 2
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      },
      {
        "state": "MI",
        "births_per_100k": 1
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "VA",
        "births_per_100k": 1
      },
      {
        "state": "NC",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "KY",
        "births_per_100k": 1
      },
      {
        "state": "TN",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michelina",
    "total_population": 903,
    "state_map": [
      {
        "state": "CT",
        "births_per_100k": 9
      },
      {
        "state": "RI",
        "births_per_100k": 9
      },
      {
        "state": "MA",
        "births_per_100k": 8
      },
      {
        "state": "NJ",
        "births_per_100k": 7
      },
      {
        "state": "NY",
        "births_per_100k": 6
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "IL",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 1920,
        "births_per_100k": 12,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaella",
    "total_population": 705,
    "state_map": [
      {
        "state": "MA",
        "births_per_100k": 6
      },
      {
        "state": "MO",
        "births_per_100k": 6
      },
      {
        "state": "WA",
        "births_per_100k": 5
      },
      {
        "state": "FL",
        "births_per_100k": 4
      },
      {
        "state": "UT",
        "births_per_100k": 3
      },
      {
        "state": "NC",
        "births_per_100k": 3
      },
      {
        "state": "OH",
        "births_per_100k": 3
      },
      {
        "state": "NY",
        "births_per_100k": 3
      },
      {
        "state": "CO",
        "births_per_100k": 3
      },
      {
        "state": "IN",
        "births_per_100k": 3
      },
      {
        "state": "PA",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "NJ",
        "births_per_100k": 2
      },
      {
        "state": "MI",
        "births_per_100k": 2
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "CA",
        "births_per_100k": 1
      },
      {
        "state": "TX",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michela",
    "total_population": 616,
    "state_map": [
      {
        "state": "MA",
        "births_per_100k": 12
      },
      {
        "state": "NY",
        "births_per_100k": 3
      },
      {
        "state": "NJ",
        "births_per_100k": 3
      },
      {
        "state": "PA",
        "births_per_100k": 2
      },
      {
        "state": "CA",
        "births_per_100k": 2
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "IL",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaelangelo",
    "total_population": 574,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 3
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "TX",
        "births_per_100k": 1
      },
      {
        "state": "MA",
        "births_per_100k": 1
      },
      {
        "state": "IL",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 2020,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michaelene",
    "total_population": 477,
    "state_map": [
      {
        "state": "PA",
        "births_per_100k": 4
      },
      {
        "state": "IL",
        "births_per_100k": 4
      },
      {
        "state": "IA",
        "births_per_100k": 2
      },
      {
        "state": "MI",
        "births_per_100k": 1
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "NJ",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 1940,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michala",
    "total_population": 465,
    "state_map": [
      {
        "state": "NC",
        "births_per_100k": 9
      },
      {
        "state": "OK",
        "births_per_100k": 7
      },
      {
        "state": "NE",
        "births_per_100k": 5
      },
      {
        "state": "VA",
        "births_per_100k": 5
      },
      {
        "state": "MO",
        "births_per_100k": 5
      },
      {
        "state": "TX",
        "births_per_100k": 4
      },
      {
        "state": "OH",
        "births_per_100k": 4
      },
      {
        "state": "MI",
        "births_per_100k": 4
      },
      {
        "state": "PA",
        "births_per_100k": 3
      },
      {
        "state": "GA",
        "births_per_100k": 3
      },
      {
        "state": "LA",
        "births_per_100k": 2
      },
      {
        "state": "TN",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "KY",
        "births_per_100k": 2
      },
      {
        "state": "WA",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "CA",
        "births_per_100k": 1
      },
      {
        "state": "MN",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    CASE WHEN base.gender='M' THEN 'Male' ELSE 'Female' END as baby_gender__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN SUM(base.number) END as cohort_population__0,
    CASE WHEN group_set=1 THEN base.name END as name__1,
    CASE WHEN group_set=1 THEN SUM(base.number) END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_current` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,5,7
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    baby_gender__0 as baby_gender,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(name__1 as name, population__1 as population) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3,4
  ORDER BY 5 desc
)
, __stage2 AS (
  SELECT
    group_set,
    concat(by_name_0.name,'') as name__0,
    CASE WHEN group_set=0 THEN SUM(by_name_0.population) END as total_population__0,
    CASE WHEN group_set=1 THEN names.state END as state__1,
    CASE WHEN group_set=1 THEN floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__1,
    CASE WHEN group_set=2 THEN names.decade END as decade__2,
    CASE WHEN group_set=2 THEN floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__2,
    CASE WHEN group_set=2 THEN names.baby_gender END as baby_gender__2
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1) as names
  , UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  WHERE concat(by_name_0.name,'') LIKE 'Mich%'
  GROUP BY 1,2,4,6,8
)
SELECT
  name__0 as name,
  ANY_VALUE(CASE WHEN group_set=0 THEN total_population__0 END) as total_population,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(state__1 as state, births_per_100k__1 as births_per_100k) END IGNORE NULLS  ORDER BY  births_per_100k__1 desc ) as state_map,
  ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(decade__2 as decade, births_per_100k__2 as births_per_100k, baby_gender__2 as baby_gender) END IGNORE NULLS  ORDER BY  births_per_100k__2 desc ) as decade_graph
FROM __stage2
GROUP BY 1
ORDER BY 2 desc
LIMIT 15

Iconic Names by State and Gender

Calculate the births per 100K for a name in general and a name within a state. Compute and sort by a ratio to figure out relative popularity.

query: names { where: decade < 1970 } -> {
  group_by: name
  group_by: gender
  aggregate: births_per_100k
  nest: by_state is {
    group_by: state
    aggregate: births_per_100k
  }
} -> {
  where: births_per_100k > 50
  group_by: by_state.state
  nest: by_gender is {
    group_by: gender
    nest: by_name is {
      top: 15
      order_by: popularity desc
      group_by: name
      aggregate: popularity is (by_state.births_per_100k - births_per_100k) / births_per_100k
    }
  }
}
QUERY RESULTS
state by_​gender
AK
gender
F
by_name
name popularity
Daisy 5.229
Shannon 2.506
Lucy 2.389
Sophie 1.918
Agnes 1.852
Tina 1.846
Deanna 1.841
Katherine 1.735
Colleen 1.652
Kristin 1.567
Leslie 1.497
Teresa 1.467
Heather 1.424
Heidi 1.364
Valerie 1.361
gender
M
by_name
name popularity
Shawn 3.153
Jason 2.708
Troy 1.667
Tracy 1.623
Sean 1.605
Peter 1.521
Patrick 1.444
Karl 1.405
Matthew 1.311
Dwayne 1.281
Darren 1.227
Eric 1.206
Mike 1.148
Andrew 1.14
Micheal 1.128
AL
gender
F
by_name
name popularity
Annie 4.751
Willie 3.772
Mattie 3.689
Johnnie 3.338
Rosie 3.034
Shelia 2.987
Katie 2.964
Fannie 2.84
Lillie 2.705
Essie 2.627
Lula 2.536
Minnie 2.412
Hattie 2.318
Mamie 2.301
Susie 2.299
gender
M
by_name
name popularity
Willie 4.273
Charlie 3.119
Roosevelt 2.824
Earnest 2.691
Jessie 2.576
Johnnie 2.554
Rickey 2.33
Eddie 2.284
Jimmie 2.24
Horace 2.129
Otis 2.1
Jimmy 2.036
Johnny 1.912
Billy 1.825
Bennie 1.793
AR
gender
F
by_name
name popularity
Rosie 3.23
Bobbie 2.79
Erma 2.773
Patsy 2.558
Billie 2.486
Ruby 2.28
Velma 2.245
Opal 2.216
Ollie 2.196
Geneva 2.163
Willie 2.117
Essie 1.941
Jessie 1.883
Shelia 1.848
Lola 1.838
gender
M
by_name
name popularity
Rickey 3.636
Billy 3.309
Bobby 3.242
Jimmy 2.891
Jessie 2.455
Earnest 2.426
Freddie 2.321
Tommy 2.281
Jimmie 2.202
Otis 2.15
Jackie 2.138
Bennie 1.897
Roosevelt 1.882
Luther 1.821
Cecil 1.748
AZ
gender
F
by_name
name popularity
Carmen 5.642
Cecilia 3.719
Maria 3.649
Lupe 3.222
Lydia 3.197
Yolanda 3
Ramona 2.556
Dora 1.956
Guadalupe 1.911
Susie 1.61
Alicia 1.606
Veronica 1.504
Christina 1.492
Rosie 1.471
Monica 1.394
gender
M
by_name
name popularity
Manuel 8.991
Ruben 5.639
Francisco 5
Carlos 4.418
Jesus 4.324
Jose 3.604
Gilbert 3.48
Antonio 3.476
Raul 3.145
Alex 3.078
Hector 2.962
Miguel 2.722
Juan 2.457
Luis 2.365
Woodrow 2.058
CA
gender
F
by_name
name popularity
Christina 1.358
Carmen 1.347
Yolanda 1.257
Teri 1.06
Maria 1.009
Pat 0.907
Cecilia 0.877
Leslie 0.848
Julie 0.837
Victoria 0.829
Monica 0.78
Ramona 0.764
Alicia 0.727
Lydia 0.724
Shannon 0.718
gender
M
by_name
name popularity
Manuel 2.327
Ruben 2
Carlos 1.468
Mario 1.231
Mike 1.196
Jason 1.069
Bob 1.036
Lance 0.982
Gilbert 0.967
Jim 0.965
Dave 0.91
Ricardo 0.873
Jose 0.86
Eric 0.829
Chris 0.824
CO
gender
F
by_name
name popularity
Kristi 1.962
Shelly 1.368
Olive 1.269
Bernadette 1.211
Ramona 1.194
Becky 1.101
Nicole 1.091
Heather 1.071
Della 1.053
Heidi 1.03
Erma 1.015
Dianna 1.015
Karla 0.968
Kelli 0.964
Shannon 0.918
gender
M
by_name
name popularity
Kent 1.944
Manuel 1.636
Kirk 1.606
Woodrow 1.558
Gilbert 1.374
Kelly 1.333
Brett 1.288
Bob 1.205
Shawn 1.119
Delbert 1.109
Rick 1.104
Mike 1.07
Jason 1.028
Dave 1
Joe 0.985
CT
gender
F
by_name
name popularity
Sophie 2.656
Doreen 2.646
Claire 1.772
Lynn 1.664
Gail 1.564
Antoinette 1.513
Kristen 1.509
Maureen 1.477
Maryann 1.461
Laurie 1.408
Marion 1.343
Jennie 1.258
Heather 1.188
Anne 1.143
Heidi 1.101
gender
M
by_name
name popularity
Peter 2.449
Nicholas 1.984
Salvatore 1.9
Jonathan 1.737
Angelo 1.643
Francis 1.475
Alexander 1.353
Vincent 1.269
Marc 1.171
Sean 1.168
Frederick 1.153
Anthony 1.022
Louis 0.966
Joseph 0.908
Theodore 0.841
DC
gender
F
by_name
name popularity
Cassandra 2.019
Crystal 2.017
Yvette 1.867
Tonya 1.833
Tanya 1.719
Gwendolyn 1.559
Leslie 1.4
Jacqueline 1.365
Delores 1.331
Laverne 1.327
Renee 1.319
Vanessa 1.316
Nicole 1.291
Monica 1.266
Yvonne 1.253
gender
M
by_name
name popularity
Tyrone 5.263
Reginald 3.785
Derrick 2.627
Maurice 1.908
Ricardo 1.764
Darryl 1.693
Dwayne 1.688
Derek 1.685
Nathaniel 1.417
Jonathan 1.331
Sean 1.261
Eric 1.219
Clifton 1.167
Bernard 1.093
Christopher 1
DE
gender
F
by_name
name popularity
Crystal 3.397
Sophie 2.869
Mabel 2.578
Stella 2.339
Hilda 2.325
Heather 2.129
Elsie 2.097
Pearl 1.839
Nicole 1.836
Agnes 1.698
Holly 1.589
Kristin 1.582
Dawn 1.519
Olive 1.519
Blanche 1.449
gender
M
by_name
name popularity
Woodrow 3.981
Francis 2.381
Sean 1.479
Matthew 1.257
Tyrone 1.246
Harry 1.212
Roland 1.168
Christopher 1.167
Franklin 1.139
Dwayne 1.063
Horace 1.048
Willard 1.047
Wayne 1.04
Bryan 1.034
Jonathan 0.907
FL
gender
F
by_name
name popularity
Cassandra 1.704
Gwendolyn 1.525
Jacquelyn 1.323
Rosa 1.043
Essie 0.98
Belinda 0.967
Ernestine 0.909
Annie 0.866
Iris 0.839
Tina 0.829
Daisy 0.829
Johnnie 0.824
Angela 0.821
Willie 0.772
Inez 0.743
gender
M
by_name
name popularity
Nathaniel 2.236
Freddie 1.744
Willie 1.716
Johnnie 1.438
Reginald 1.367
Roosevelt 1.235
Horace 1.177
Eddie 1.096
Charlie 0.902
Derrick 0.896
Jimmie 0.845
Johnny 0.843
Dwayne 0.766
Tyrone 0.754
Earnest 0.75
GA
gender
F
by_name
name popularity
Annie 3.997
Mattie 3.763
Willie 3.178
Essie 3.098
Mamie 3.027
Johnnie 2.73
Susie 2.494
Fannie 2.444
Lillie 2.409
Hattie 2.282
Katie 2.25
Sara 2.183
Rosa 2.173
Daisy 2.071
Lucile 2.068
gender
M
by_name
name popularity
Charlie 4.636
Willie 4.57
Horace 3.081
Otis 2.733
Bennie 2.483
Johnnie 2.438
Eddie 2.391
Freddie 2.115
Nathaniel 2.083
Earnest 2.074
Johnny 2.044
Marion 1.813
Roosevelt 1.804
Hugh 1.772
Hubert 1.769
HI
gender
F
by_name
name popularity
Kiyoko 6.789
Yoshiko 6.393
Masako 5.984
Fumiko 5.911
Mitsue 5.868
Shizue 4.775
Roxanne 4.723
Bernadette 4.579
Yoshie 4.027
Shizuko 3.975
Kikue 3.966
Iris 3.911
Mitsuko 3.888
Violet 3.632
Doreen 3.415
gender
M
by_name
name popularity
Toshio 7.902
Yoshio 7.885
Kiyoshi 6.985
Kazuo 6.426
Lance 6.089
Minoru 5.981
Derek 5.833
Takeo 4.941
Jason 4.792
Clayton 4.373
Shigeo 4.311
Nathan 3.968
Guy 3.588
Wendell 3.208
Sean 3.092
IA
gender
F
by_name
name popularity
Becky 1.927
Karla 1.921
Maxine 1.826
Shelly 1.821
Kristi 1.577
Julie 1.523
Jodi 1.443
Sheryl 1.403
Marcella 1.339
Connie 1.327
Tami 1.302
Erma 1.288
Jody 1.269
Kristine 1.227
Roxanne 1.108
gender
M
by_name
name popularity
Lyle 3.762
Duane 2.508
Kent 2.113
Dean 2.096
Woodrow 1.788
Darin 1.774
Max 1.685
Bradley 1.61
Rick 1.584
Delbert 1.564
Virgil 1.487
Dale 1.471
Lynn 1.45
Jon 1.441
Rex 1.439
ID
gender
F
by_name
name popularity
Olive 3.808
Karla 3.206
Heather 2.929
Shannon 2.812
Shelley 2.73
Kristi 2.558
Maxine 2.53
Becky 2.468
Blanche 2.359
Tamara 2.342
Robyn 2.17
Tami 2.159
Jody 2.119
Opal 2.093
Shelly 2.019
gender
M
by_name
name popularity
Kelly 5.944
Brent 5.598
Darin 5.453
Lynn 5.2
Woodrow 4.231
Kim 3.879
Kent 3.775
Lyle 3.413
Rex 3.368
Max 2.973
Tracy 2.803
Brett 2.493
Brad 2.462
Delbert 2.4
Rick 2.264
IL
gender
F
by_name
name popularity
Laverne 1.273
Dolores 0.667
Rosemary 0.612
Lorraine 0.606
Genevieve 0.604
Marcella 0.581
Pat 0.556
Marianne 0.5
Marilyn 0.459
Judith 0.416
Loretta 0.383
Arlene 0.37
Eileen 0.354
Bernice 0.348
Kristine 0.33
gender
M
by_name
name popularity
Jerome 0.604
Derrick 0.537
Tyrone 0.474
Maurice 0.429
Bradley 0.366
Tom 0.336
Lyle 0.333
Brad 0.295
Chester 0.273
Patrick 0.264
Kurt 0.256
Lawrence 0.252
Bob 0.25
Martin 0.248
Darryl 0.248
IN
gender
F
by_name
name popularity
Tamara 1.351
Patty 1.193
Tina 1.146
Wilma 1.017
Penny 0.969
Beth 0.96
Marsha 0.952
Olive 0.942
Sue 0.937
Lana 0.922
Dianna 0.912
Becky 0.826
Tonya 0.822
Marcia 0.814
Rebecca 0.755
gender
M
by_name
name popularity
Max 2.37
Rex 1.93
Kent 1.338
Rick 1.28
Brent 1.134
Bradley 1.033
Jeffery 0.967
Jeff 0.954
Tim 0.946
Wilbur 0.905
Darrin 0.885
Kerry 0.879
Darin 0.868
Garry 0.833
Terry 0.754
KS
gender
F
by_name
name popularity
Karla 2.111
Kristi 1.923
Maxine 1.811
Shelly 1.792
Wilma 1.73
Opal 1.557
Deanna 1.449
Connie 1.414
Velma 1.392
Lana 1.373
Lola 1.294
Dana 1.259
Beulah 1.233
Dianna 1.221
Sheryl 1.202
gender
M
by_name
name popularity
Darin 3.528
Max 2.452
Rex 2.281
Delbert 2.2
Kelly 2.167
Virgil 2.013
Lyle 1.984
Kent 1.873
Bradley 1.634
Brad 1.526
Bob 1.375
Brent 1.329
Duane 1.234
Everett 1.231
Marion 1.213
KY
gender
F
by_name
name popularity
Geneva 2.827
Della 2.07
Opal 1.969
Shelia 1.797
Wilma 1.759
Beulah 1.616
Ruby 1.472
Wanda 1.425
Vickie 1.357
Ada 1.348
Alma 1.273
Nora 1.2
Myrtle 1.183
Thelma 1.103
Eula 1.097
gender
M
by_name
name popularity
Donnie 3.343
Jackie 2.255
Wendell 1.792
Homer 1.729
Virgil 1.718
Cecil 1.687
Ronnie 1.646
Bobby 1.596
Billy 1.596
Hubert 1.538
Garry 1.5
Everett 1.462
Danny 1.368
Willard 1.365
Luther 1.328
LA
gender
F
by_name
name popularity
Shelia 2.582
Irma 1.824
Eula 1.758
Rosie 1.713
Vanessa 1.663
Gwendolyn 1.619
Mable 1.581
Lillie 1.43
Hilda 1.373
Bobbie 1.31
Glenda 1.306
Ella 1.302
Willie 1.284
Cassandra 1.241
Paulette 1.217
gender
M
by_name
name popularity
Sidney 2.385
Clifton 2.25
Freddie 2.231
Alvin 2.071
Roosevelt 1.98
Jessie 1.909
Dwayne 1.719
Willie 1.635
Tyrone 1.491
Oliver 1.49
Kerry 1.466
Herman 1.43
Earnest 1.412
Calvin 1.401
Byron 1.358
MA
gender
F
by_name
name popularity
Claire 5.013
Maureen 3.052
Priscilla 2.288
Lynne 1.826
Jeannette 1.779
Anne 1.585
Joanne 1.524
Doreen 1.477
Eleanor 1.475
Muriel 1.418
Sophie 1.393
Marion 1.295
Eileen 1.282
Jeanne 1.277
Lorraine 1.236
gender
M
by_name
name popularity
Francis 2.843
Peter 2.057
Gerard 2.014
Dana 1.87
Roland 1.642
Leo 1.503
Frederick 1.281
Stephen 1.266
Philip 1.186
Paul 1.179
Jonathan 1.144
Alfred 1.028
Sean 0.966
Arthur 0.903
Joseph 0.856
MD
gender
F
by_name
name popularity
Crystal 1.638
Hilda 1.325
Vanessa 1.306
Yvette 1.217
Robin 1.016
Rosalie 0.887
Darlene 0.885
Bernadette 0.825
Dawn 0.814
Terry 0.803
Catherine 0.803
Tracey 0.761
Regina 0.75
Naomi 0.75
Michele 0.749
gender
M
by_name
name popularity
Tyrone 2.07
Dwayne 1.484
Roland 1.221
Reginald 1.127
Clifton 1.117
Bernard 1.07
Maurice 0.969
Franklin 0.869
Melvin 0.861
Milton 0.86
Vernon 0.84
Jerome 0.832
Harry 0.803
Nelson 0.732
Darrin 0.731
ME
gender
F
by_name
name popularity
Priscilla 4.3
Jeannette 3.632
Muriel 3.313
Olive 2.654
Claire 2.506
Constance 2.305
Pauline 2.265
Madeline 2.067
Laurie 1.937
Rachel 1.85
Debora 1.667
Kristen 1.623
Marguerite 1.621
Heidi 1.576
Tina 1.529
gender
M
by_name
name popularity
Dana 7.278
Roland 6.516
Woodrow 4.308
Gerard 3.722
Maurice 3.633
Clayton 2.864
Reginald 2.62
Everett 2.359
Troy 2.141
Philip 2.01
Adam 1.963
Normand 1.852
Marc 1.714
Leo 1.693
Shawn 1.619
MI
gender
F
by_name
name popularity
Sally 0.76
Dawn 0.74
Colleen 0.652
Sue 0.626
Julie 0.616
Marcia 0.603
Kay 0.579
Genevieve 0.56
Kelly 0.556
Suzanne 0.528
Marlene 0.513
Michelle 0.491
Renee 0.488
Sheryl 0.476
Shelly 0.462
gender
M
by_name
name popularity
Duane 1.065
Gerald 0.939
Kim 0.862
Gordon 0.855
Dave 0.836
Lyle 0.825
Rick 0.784
Darrin 0.731
Dale 0.692
Fredrick 0.673
Kurt 0.616
Kirk 0.606
Douglas 0.556
Dennis 0.534
Tim 0.514
MN
gender
F
by_name
name popularity
Jodi 2.545
Jody 2.06
Marcella 2
Kristin 1.881
Roxanne 1.862
Kristine 1.716
Kristi 1.712
Colleen 1.553
Harriet 1.542
Julie 1.472
Lorraine 1.407
Heidi 1.394
Delores 1.324
Shelly 1.321
Marlene 1.256
gender
M
by_name
name popularity
Lyle 3.079
Duane 2.919
Bradley 2.675
Jerome 1.96
Dean 1.955
Jason 1.889
Darin 1.642
Gordon 1.62
Todd 1.536
Jon 1.469
Troy 1.43
Dale 1.399
Arnold 1.366
Allan 1.294
Scott 1.268
MO
gender
F
by_name
name popularity
Wilma 1.471
Opal 1.155
Laverne 1.073
Velma 0.931
Marcella 0.855
Lana 0.824
Christy 0.804
Beulah 0.756
Carla 0.745
Shelly 0.736
Glenda 0.729
Georgia 0.726
Norma 0.717
Erma 0.712
Marsha 0.644
gender
M
by_name
name popularity
Virgil 1.397
Darin 1.113
Bob 1.045
Jackie 1.021
Everett 0.923
Delbert 0.909
Bill 0.847
Elmer 0.803
Garry 0.7
Vernon 0.686
Lloyd 0.676
Floyd 0.673
Oliver 0.647
Billy 0.641
Marion 0.6
MS
gender
F
by_name
name popularity
Rosie 8.402
Annie 5.016
Willie 4.904
Bobbie 4.2
Maggie 4.078
Mattie 4.052
Katie 4.036
Lillie 4
Hattie 3.988
Essie 3.902
Johnnie 3.824
Lula 3.738
Fannie 3.42
Minnie 3.176
Jessie 3.039
gender
M
by_name
name popularity
Willie 6.282
Roosevelt 6.078
Jessie 5.535
Johnnie 4.339
Eddie 3.863
Earnest 3.794
Jimmie 3.744
Charlie 3.734
Bennie 3.569
Clifton 2.85
Otis 2.8
Luther 2.373
Sam 2.349
Freddie 2.192
Johnny 1.96
MT
gender
F
by_name
name popularity
Tami 2.683
Mabel 2.667
Pat 2.593
Jamie 2.521
Shelly 2.5
Teri 2.418
Olive 2.385
Karla 2.302
Kristi 2.192
Patti 2.119
Genevieve 2.066
Colleen 1.929
Shannon 1.906
Shelley 1.899
Marlene 1.776
gender
M
by_name
name popularity
Kelly 3
Lyle 2.714
Shawn 2.407
Woodrow 2.288
Brett 2.123
Jason 1.972
Brad 1.962
Darin 1.925
Duane 1.887
Darren 1.814
Kirk 1.761
Dan 1.722
Tim 1.676
Lance 1.625
Rick 1.608
NC
gender
F
by_name
name popularity
Annie 3.016
Maggie 2.313
Katie 2.143
Hattie 2.129
Mamie 1.973
Sadie 1.893
Mable 1.71
Lillie 1.604
Shelia 1.557
Rosa 1.554
Fannie 1.469
Hilda 1.458
Rachel 1.425
Crystal 1.414
Daisy 1.4
gender
M
by_name
name popularity
Charlie 2.713
Clifton 2.2
Bobby 2.021
Hubert 1.969
Luther 1.955
Johnnie 1.688
Donnie 1.687
Horace 1.645
Clyde 1.424
Claude 1.418
Willie 1.374
Johnny 1.372
Ricky 1.286
Jimmy 1.258
Marshall 1.197
ND
gender
F
by_name
name popularity
Kristi 6.346
Karla 5.429
Violet 4.057
Myrtle 3.603
Shelly 3.472
Viola 3.297
Roxanne 3.277
Jodi 3.136
Marlene 3.135
Paulette 3.043
Olga 2.853
Hilda 2.831
Olive 2.692
Leona 2.642
Delores 2.615
gender
M
by_name
name popularity
Lyle 6.333
Darin 6.132
Troy 5.985
Duane 5.839
Kelly 3.611
Brent 3.305
Darren 3.206
Bradley 3
Lynn 2.967
Jason 2.819
Arnold 2.554
Gordon 2.53
Vernon 2.526
Kim 2.466
Dean 2.436
NE
gender
F
by_name
name popularity
Kristi 3.192
Opal 2.742
Erma 2.197
Maxine 2.023
Shelly 1.934
Jody 1.522
Tami 1.492
Jodi 1.409
Julie 1.408
Olive 1.404
Leona 1.377
Wilma 1.356
Kay 1.306
Deanna 1.243
Christy 1.235
gender
M
by_name
name popularity
Lyle 4.508
Duane 2.46
Darin 2.377
Kent 2.141
Dean 1.814
Dale 1.805
Bradley 1.805
Delbert 1.709
Rex 1.649
Virgil 1.628
Troy 1.607
Lynn 1.55
Kirk 1.493
Rick 1.408
Kelly 1.403
NH
gender
F
by_name
name popularity
Kristen 6.698
Claire 6.203
Jeannette 4.912
Priscilla 4.863
Heidi 3.889
Blanche 3.808
Muriel 3.612
Olive 3.385
Pauline 3.313
Nicole 2.745
Kristin 2.597
Sophie 2.508
Stella 2.492
Lorraine 2.175
Gertrude 2.155
gender
M
by_name
name popularity
Roland 7.726
Maurice 6.01
Gerard 5.139
Dana 4.426
Marc 3.181
Leo 2.687
Normand 2.309
Shawn 2.153
Jonathan 2.136
Peter 1.978
Norman 1.954
Roger 1.828
Jason 1.611
Bruce 1.494
Scott 1.345
NJ
gender
F
by_name
name popularity
Maryann 2.289
Claire 1.873
Eileen 1.578
Antoinette 1.526
Angelina 1.462
Rosemarie 1.418
Madeline 1.28
Maureen 1.267
Marianne 1.214
Michele 1.148
Doreen 1.138
Joan 1.03
Eleanor 0.993
Marion 0.971
Sophie 0.967
gender
M
by_name
name popularity
Nicholas 2.146
Dominick 1.961
Angelo 1.911
Vincent 1.671
Peter 1.492
Alexander 1.294
Salvatore 1.289
Anthony 1.23
Gerard 1.167
Joseph 1.147
Frank 0.95
Louis 0.931
Frederick 0.803
Edward 0.785
Theodore 0.785
NM
gender
F
by_name
name popularity
Cecilia 6
Ramona 4.694
Carmen 4.421
Bernadette 3.965
Maria 3.782
Lucy 3.595
Priscilla 3.563
Flora 2.969
Yolanda 2.771
Dora 2.67
Marcella 2.645
Lydia 2.421
Lupe 2.222
Stella 2.161
Rosie 2.115
gender
M
by_name
name popularity
Manuel 10.227
Jose 7.425
Antonio 5.476
Gilbert 5.228
Ruben 5.016
Juan 4.843
Carlos 4.278
Joe 3.835
Pedro 2.887
Alex 2.766
Luis 2.765
Francisco 2.75
Miguel 2.741
Jesus 2.676
Bennie 2.517
NV
gender
F
by_name
name popularity
Olga 5.103
Traci 4.339
Shannon 4.2
Stacey 4.148
Pat 3.981
Toni 3.165
Natalie 3.15
Teri 3.015
Kelli 2.982
Marguerite 2.947
Tina 2.888
Blanche 2.795
Tami 2.746
Nicole 2.745
Leslie 2.673
gender
M
by_name
name popularity
Jason 4.333
Shawn 4.178
Troy 4.022
Kelly 3.736
Woodrow 3.654
Lance 2.982
Darren 2.711
Mike 2.526
Brent 2
Adam 2
Aaron 1.986
Darin 1.962
Brett 1.959
Delbert 1.891
Tracy 1.639
NY
gender
F
by_name
name popularity
Antoinette 1.756
Eileen 1.675
Madeline 1.653
Miriam 1.618
Muriel 1.567
Angelina 1.5
Rosemarie 1.463
Maureen 1.355
Maryann 1.158
Marion 1
Josephine 1
Claire 0.987
Anne 0.987
Joan 0.915
Doreen 0.908
gender
M
by_name
name popularity
Salvatore 2.222
Angelo 2.054
Dominick 2.039
Vincent 1.963
Nicholas 1.797
Gerard 1.792
Peter 1.687
Stuart 1.21
Anthony 1.184
Seymour 1.111
Alexander 1.035
Martin 0.915
Neil 0.908
Philip 0.89
Louis 0.849
OH
gender
F
by_name
name popularity
Beth 0.678
Patty 0.651
Sue 0.638
Amy 0.591
Marcella 0.5
Dianna 0.456
Becky 0.45
Tonya 0.433
Kimberly 0.422
Rosemary 0.412
Marcia 0.397
Darla 0.397
Penny 0.394
Sandy 0.392
Marilyn 0.39
gender
M
by_name
name popularity
Rick 0.776
Tim 0.703
Dave 0.687
Dale 0.597
Wilbur 0.587
Darrin 0.519
Jeffrey 0.499
Tom 0.493
Timothy 0.481
Jeffery 0.475
Jeff 0.424
Ted 0.41
Karl 0.369
Carl 0.356
Dwight 0.351
OK
gender
F
by_name
name popularity
Opal 4.134
Billie 3.706
Shelly 2.396
Velma 2.196
Kristi 2.192
Patsy 2.154
Darla 2.138
Wanda 2.114
Wilma 1.931
Geneva 1.786
Lola 1.765
Juanita 1.704
Erma 1.682
Kelli 1.655
Ruby 1.609
gender
M
by_name
name popularity
Billy 3.137
Jackie 2.713
Jimmie 2.543
Jimmy 2.367
Tommy 2.292
Bill 2.243
Cecil 2.148
Bobby 2.11
Delbert 2.036
Bob 1.964
Virgil 1.833
Floyd 1.752
Rickey 1.67
Don 1.535
Ronnie 1.472
OR
gender
F
by_name
name popularity
Tami 3.095
Shannon 2.647
Shelley 1.944
Julie 1.912
Kristi 1.904
Tamara 1.883
Lucile 1.695
Shelly 1.679
Jan 1.557
Becky 1.477
Deanna 1.449
Kelli 1.436
Teri 1.433
Karla 1.413
Traci 1.371
gender
M
by_name
name popularity
Darin 2.981
Woodrow 2.75
Kelly 2.569
Rick 2.16
Jason 2.028
Jim 1.849
Bob 1.786
Dan 1.722
Dave 1.657
Brad 1.603
Delbert 1.6
Jeff 1.583
Mike 1.561
Lyle 1.524
Bradley 1.512
PA
gender
F
by_name
name popularity
Anna 1.388
Dolores 1.13
Maryann 1.053
Eleanor 0.979
Miriam 0.974
Bernadette 0.965
Marian 0.748
Sophie 0.738
Rosemarie 0.716
Agnes 0.711
Helen 0.692
Florence 0.687
Stella 0.627
Joanne 0.622
Marianne 0.6
gender
M
by_name
name popularity
Francis 1.395
Harry 1.147
Joseph 1.013
Nicholas 0.919
Barry 0.713
Bernard 0.668
Vincent 0.598
Edward 0.595
Andrew 0.556
Samuel 0.552
Theodore 0.528
Alexander 0.482
Albert 0.463
Stanley 0.452
Frank 0.441
RI
gender
F
by_name
name popularity
Claire 7.051
Kristen 4.245
Muriel 4.164
Angelina 4
Doreen 3.4
Maureen 3.221
Jeannette 3.015
Madeline 2.48
Flora 2.313
Jennie 2.289
Gertrude 2.208
Laurie 2.103
Gail 2.011
Olga 1.956
Sophie 1.951
gender
M
by_name
name popularity
Roland 4.263
Gerard 3.167
Normand 2.901
Angelo 2.357
Leo 2.307
Marc 2.276
Alfred 1.968
Peter 1.891
Manuel 1.818
Raymond 1.765
Francis 1.642
Maurice 1.551
Vincent 1.521
Antonio 1.476
Anthony 1.322
SC
gender
F
by_name
name popularity
Hattie 4.224
Rosa 4.094
Maggie 3.984
Janie 3.949
Annie 3.816
Mamie 3.753
Daisy 3.543
Lillie 3.517
Sadie 3.125
Carrie 3.114
Essie 2.804
Lula 2.69
Mattie 2.63
Willie 2.406
Jessie 2.266
gender
M
by_name
name popularity
Marion 4.875
Nathaniel 4.375
Willie 3.948
Roosevelt 3.333
Woodrow 2.827
Luther 2.716
Johnnie 2.589
Julius 2.571
Leroy 2.512
Charlie 2.406
Bennie 2.345
Freddie 2.154
Otis 2.133
Horace 2.097
Ben 1.761
SD
gender
F
by_name
name popularity
Kristi 4.404
Karla 3.937
Darla 3.362
Tamara 2.775
Jody 2.612
Violet 2.566
Mabel 2.559
Kay 2.521
Delores 2.439
Maxine 2.348
Verna 2.284
Viola 2.281
Olive 2.173
Leona 2.17
Lana 2.078
gender
M
by_name
name popularity
Lyle 7.286
Darin 4.962
Kelly 4.236
Duane 4.089
Bradley 3.211
Brad 2.628
Troy 2.556
Todd 2.431
Delbert 2.364
Dean 2.301
Dale 2.231
Elmer 1.909
Daryl 1.897
Kim 1.862
Virgil 1.859
TN
gender
F
by_name
name popularity
Shelia 2.772
Bobbie 1.82
Wilma 1.569
Ruby 1.562
Patsy 1.538
Billie 1.477
Mattie 1.452
Glenda 1.403
Geneva 1.398
Willie 1.391
Maggie 1.375
Melissa 1.251
Wanda 1.229
Tonya 1.211
Johnnie 1.203
gender
M
by_name
name popularity
Billy 2.384
Jackie 2.266
Bobby 2.217
Rickey 2.011
Donnie 1.97
Jimmy 1.895
Ronnie 1.722
Hubert 1.6
Luther 1.597
Claude 1.538
Tommy 1.503
Johnny 1.482
Ricky 1.479
Hugh 1.405
Charlie 1.28
TX
gender
F
by_name
name popularity
Maria 5.032
Guadalupe 2.744
Yolanda 2.695
Billie 2.495
Irma 2.365
Rosa 2.338
Alicia 2.303
Janie 2.179
Dora 1.835
Olga 1.779
Bobbie 1.6
Patsy 1.596
Carmen 1.589
Lydia 1.579
Juanita 1.552
gender
M
by_name
name popularity
Juan 5.606
Jose 4.903
Ruben 4.508
Manuel 4.036
Jesus 3.765
Pedro 3.677
Roberto 3.618
Ricardo 3.527
Raul 3.493
Carlos 3.316
Francisco 3.309
Antonio 3.274
Hector 2.528
Guadalupe 2.477
Joe 2.128
UT
gender
F
by_name
name popularity
Robyn 5.604
Sherrie 4.569
Kristine 3.341
Erma 3.182
Natalie 3.167
Becky 3.028
Colleen 3.014
Jan 2.949
Julie 2.747
Jody 2.373
Heidi 2.303
Lucile 2.22
Leslie 2.176
Teri 2.104
Shelly 2.094
gender
M
by_name
name popularity
Brent 10.183
Lynn 9
Kelly 7.111
Kent 7.07
Kim 5.931
Darin 5.528
Woodrow 5.365
Brad 4.5
Max 4.137
Troy 4.03
Rex 3.93
Tracy 3.246
Kerry 3.034
Don 2.979
Jay 2.955
VA
gender
F
by_name
name popularity
Nannie 1.721
Vanessa 1.51
Rosa 1.331
Shelia 1.329
Lucy 1.229
Fannie 1.062
Elsie 1.055
Susie 1.052
Thelma 0.97
Hattie 0.965
Iris 0.964
Nellie 0.962
Angela 0.928
Virginia 0.922
Estelle 0.909
gender
M
by_name
name popularity
Charlie 1.762
Clifton 1.7
Claude 1.626
Lewis 1.472
Luther 1.403
Calvin 1.238
Earnest 1.191
Otis 1.183
Marshall 1.115
Cecil 1.113
Nelson 1.089
Reginald 1.051
Franklin 1.033
Woodrow 1.019
Clarence 0.974
VT
gender
F
by_name
name popularity
Madeline 4.8
Marion 4.135
Laurie 4.013
Blanche 3.936
Claire 3.481
Olive 3
Priscilla 2.913
Heather 2.835
Heidi 2.737
Penny 2.276
Marguerite 2.274
Pauline 2.273
Muriel 2.269
Tina 2.246
Jeannette 2.162
gender
M
by_name
name popularity
Jason 4.139
Reginald 3.696
Maurice 3.694
Roland 3.368
Dana 3.315
Wendell 2.717
Francis 2.635
Bernard 2.495
Gordon 2.458
Everett 2.244
Sean 2.151
Shawn 2.144
Clayton 2
Kim 1.793
Todd 1.763
WA
gender
F
by_name
name popularity
Tami 2.968
Shannon 2.2
Kristi 1.788
Heidi 1.707
Olive 1.673
Shelley 1.663
Kelli 1.655
Colleen 1.645
Kristine 1.5
Teri 1.388
Pat 1.259
Tamara 1.234
Gayle 1.138
Julie 1.133
Deanna 1.121
gender
M
by_name
name popularity
Kelly 2.236
Woodrow 2.192
Rick 2.04
Dave 2
Bob 1.929
Jim 1.849
Dan 1.765
Jason 1.667
Jeff 1.629
Mike 1.57
Brad 1.372
Gordon 1.355
Greg 1.355
Bill 1.28
Jon 1.214
WI
gender
F
by_name
name popularity
Kristine 2.83
Laverne 2.455
Jodi 1.784
Marcella 1.726
Kristin 1.328
Lynn 1.327
Sophie 1.279
Kay 1.223
Julie 1.157
Jody 1.134
Lorraine 1.077
Violet 1.057
Jill 1.034
Arlene 1.012
Audrey 0.946
gender
M
by_name
name popularity
Jerome 2.107
Lyle 2.032
Todd 1.807
Duane 1.637
Dean 1.385
Kurt 1.384
Gordon 1.217
Dale 1.156
Jon 1.131
Allan 1.129
Gerald 1.09
Scott 1.078
Arnold 0.92
Gregg 0.882
Jeffrey 0.806
WV
gender
F
by_name
name popularity
Patty 2.241
Opal 1.969
Dianna 1.779
Beulah 1.779
Violet 1.774
Mabel 1.676
Naomi 1.607
Nellie 1.481
Della 1.386
Tammy 1.354
Wilma 1.339
Sherri 1.151
Nina 1.138
Thelma 1.122
Maxine 1.053
gender
M
by_name
name popularity
Jackie 2.606
Delbert 2.2
Homer 2.043
Franklin 2
Woodrow 1.654
Cecil 1.652
Virgil 1.59
Willard 1.424
Everett 1.282
Dana 1.259
Clyde 1.185
Roger 1.109
Danny 1.036
Luther 1.015
Lewis 1.007
WY
gender
F
by_name
name popularity
Pat 3.074
Shannon 2.894
Becky 2.798
Shelley 2.551
Natalie 2.483
Jody 2.418
Jamie 2.366
Stacy 2.313
Agnes 2.289
Shelly 2.104
Violet 2.094
Olive 2
Laurie 1.982
Hazel 1.974
Opal 1.928
gender
M
by_name
name popularity
Troy 5.941
Jason 4.431
Kelly 3.75
Kim 3.552
Brad 3.192
Kent 2.901
Woodrow 2.596
Brett 2.548
Lance 2.536
Bob 2.277
Darin 2.038
Jim 1.959
Bill 1.693
Darren 1.67
Bradley 1.659
[
  {
    "state": "AK",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Daisy",
            "popularity": 5.228571428571429
          },
          {
            "name": "Shannon",
            "popularity": 2.5058823529411764
          },
          {
            "name": "Lucy",
            "popularity": 2.3893129770992365
          },
          {
            "name": "Sophie",
            "popularity": 1.9180327868852458
          },
          {
            "name": "Agnes",
            "popularity": 1.8523489932885906
          },
          {
            "name": "Tina",
            "popularity": 1.8458333333333334
          },
          {
            "name": "Deanna",
            "popularity": 1.841121495327103
          },
          {
            "name": "Katherine",
            "popularity": 1.7352941176470589
          },
          {
            "name": "Colleen",
            "popularity": 1.6524822695035462
          },
          {
            "name": "Kristin",
            "popularity": 1.5671641791044777
          },
          {
            "name": "Leslie",
            "popularity": 1.496969696969697
          },
          {
            "name": "Teresa",
            "popularity": 1.4666666666666666
          },
          {
            "name": "Heather",
            "popularity": 1.423529411764706
          },
          {
            "name": "Heidi",
            "popularity": 1.3636363636363635
          },
          {
            "name": "Valerie",
            "popularity": 1.360655737704918
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Shawn",
            "popularity": 3.152542372881356
          },
          {
            "name": "Jason",
            "popularity": 2.7083333333333335
          },
          {
            "name": "Troy",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Tracy",
            "popularity": 1.6229508196721312
          },
          {
            "name": "Sean",
            "popularity": 1.6050420168067228
          },
          {
            "name": "Peter",
            "popularity": 1.5207877461706782
          },
          {
            "name": "Patrick",
            "popularity": 1.4444444444444444
          },
          {
            "name": "Karl",
            "popularity": 1.4047619047619047
          },
          {
            "name": "Matthew",
            "popularity": 1.3108108108108107
          },
          {
            "name": "Dwayne",
            "popularity": 1.28125
          },
          {
            "name": "Darren",
            "popularity": 1.2268041237113403
          },
          {
            "name": "Eric",
            "popularity": 1.206451612903226
          },
          {
            "name": "Mike",
            "popularity": 1.1478260869565218
          },
          {
            "name": "Andrew",
            "popularity": 1.1396648044692737
          },
          {
            "name": "Micheal",
            "popularity": 1.128
          }
        ]
      }
    ]
  },
  {
    "state": "AL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 4.750778816199377
          },
          {
            "name": "Willie",
            "popularity": 3.771573604060914
          },
          {
            "name": "Mattie",
            "popularity": 3.688888888888889
          },
          {
            "name": "Johnnie",
            "popularity": 3.3378378378378377
          },
          {
            "name": "Rosie",
            "popularity": 3.0344827586206895
          },
          {
            "name": "Shelia",
            "popularity": 2.9873417721518987
          },
          {
            "name": "Katie",
            "popularity": 2.9642857142857144
          },
          {
            "name": "Fannie",
            "popularity": 2.8395061728395063
          },
          {
            "name": "Lillie",
            "popularity": 2.704697986577181
          },
          {
            "name": "Essie",
            "popularity": 2.627450980392157
          },
          {
            "name": "Lula",
            "popularity": 2.5357142857142856
          },
          {
            "name": "Minnie",
            "popularity": 2.4122137404580153
          },
          {
            "name": "Hattie",
            "popularity": 2.3176470588235296
          },
          {
            "name": "Mamie",
            "popularity": 2.3013698630136985
          },
          {
            "name": "Susie",
            "popularity": 2.2987012987012987
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Willie",
            "popularity": 4.27348643006263
          },
          {
            "name": "Charlie",
            "popularity": 3.1188811188811187
          },
          {
            "name": "Roosevelt",
            "popularity": 2.823529411764706
          },
          {
            "name": "Earnest",
            "popularity": 2.6911764705882355
          },
          {
            "name": "Jessie",
            "popularity": 2.5757575757575757
          },
          {
            "name": "Johnnie",
            "popularity": 2.5535714285714284
          },
          {
            "name": "Rickey",
            "popularity": 2.3295454545454546
          },
          {
            "name": "Eddie",
            "popularity": 2.284263959390863
          },
          {
            "name": "Jimmie",
            "popularity": 2.24031007751938
          },
          {
            "name": "Horace",
            "popularity": 2.129032258064516
          },
          {
            "name": "Otis",
            "popularity": 2.1
          },
          {
            "name": "Jimmy",
            "popularity": 2.036363636363636
          },
          {
            "name": "Johnny",
            "popularity": 1.9124087591240877
          },
          {
            "name": "Billy",
            "popularity": 1.825436408977556
          },
          {
            "name": "Bennie",
            "popularity": 1.793103448275862
          }
        ]
      }
    ]
  },
  {
    "state": "AR",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rosie",
            "popularity": 3.2298850574712645
          },
          {
            "name": "Bobbie",
            "popularity": 2.79
          },
          {
            "name": "Erma",
            "popularity": 2.772727272727273
          },
          {
            "name": "Patsy",
            "popularity": 2.5576923076923075
          },
          {
            "name": "Billie",
            "popularity": 2.4862385321100917
          },
          {
            "name": "Ruby",
            "popularity": 2.279503105590062
          },
          {
            "name": "Velma",
            "popularity": 2.2450980392156863
          },
          {
            "name": "Opal",
            "popularity": 2.216494845360825
          },
          {
            "name": "Ollie",
            "popularity": 2.196078431372549
          },
          {
            "name": "Geneva",
            "popularity": 2.163265306122449
          },
          {
            "name": "Willie",
            "popularity": 2.116751269035533
          },
          {
            "name": "Essie",
            "popularity": 1.9411764705882353
          },
          {
            "name": "Jessie",
            "popularity": 1.8828125
          },
          {
            "name": "Shelia",
            "popularity": 1.8481012658227849
          },
          {
            "name": "Lola",
            "popularity": 1.838235294117647
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Rickey",
            "popularity": 3.6363636363636362
          },
          {
            "name": "Billy",
            "popularity": 3.309226932668329
          },
          {
            "name": "Bobby",
            "popularity": 3.241590214067278
          },
          {
            "name": "Jimmy",
            "popularity": 2.890909090909091
          },
          {
            "name": "Jessie",
            "popularity": 2.4545454545454546
          },
          {
            "name": "Earnest",
            "popularity": 2.426470588235294
          },
          {
            "name": "Freddie",
            "popularity": 2.3205128205128207
          },
          {
            "name": "Tommy",
            "popularity": 2.280701754385965
          },
          {
            "name": "Jimmie",
            "popularity": 2.201550387596899
          },
          {
            "name": "Otis",
            "popularity": 2.15
          },
          {
            "name": "Jackie",
            "popularity": 2.1382978723404253
          },
          {
            "name": "Bennie",
            "popularity": 1.896551724137931
          },
          {
            "name": "Roosevelt",
            "popularity": 1.8823529411764706
          },
          {
            "name": "Luther",
            "popularity": 1.8208955223880596
          },
          {
            "name": "Cecil",
            "popularity": 1.7478260869565216
          }
        ]
      }
    ]
  },
  {
    "state": "AZ",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Carmen",
            "popularity": 5.6421052631578945
          },
          {
            "name": "Cecilia",
            "popularity": 3.719298245614035
          },
          {
            "name": "Maria",
            "popularity": 3.6487341772151898
          },
          {
            "name": "Lupe",
            "popularity": 3.2222222222222223
          },
          {
            "name": "Lydia",
            "popularity": 3.1973684210526314
          },
          {
            "name": "Yolanda",
            "popularity": 3
          },
          {
            "name": "Ramona",
            "popularity": 2.5555555555555554
          },
          {
            "name": "Dora",
            "popularity": 1.956043956043956
          },
          {
            "name": "Guadalupe",
            "popularity": 1.9111111111111112
          },
          {
            "name": "Susie",
            "popularity": 1.6103896103896105
          },
          {
            "name": "Alicia",
            "popularity": 1.606060606060606
          },
          {
            "name": "Veronica",
            "popularity": 1.5044247787610618
          },
          {
            "name": "Christina",
            "popularity": 1.4916666666666667
          },
          {
            "name": "Rosie",
            "popularity": 1.471264367816092
          },
          {
            "name": "Monica",
            "popularity": 1.3944954128440368
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 8.99090909090909
          },
          {
            "name": "Ruben",
            "popularity": 5.639344262295082
          },
          {
            "name": "Francisco",
            "popularity": 5
          },
          {
            "name": "Carlos",
            "popularity": 4.417721518987341
          },
          {
            "name": "Jesus",
            "popularity": 4.323529411764706
          },
          {
            "name": "Jose",
            "popularity": 3.603864734299517
          },
          {
            "name": "Gilbert",
            "popularity": 3.4796747967479673
          },
          {
            "name": "Antonio",
            "popularity": 3.4761904761904763
          },
          {
            "name": "Raul",
            "popularity": 3.1449275362318843
          },
          {
            "name": "Alex",
            "popularity": 3.078125
          },
          {
            "name": "Hector",
            "popularity": 2.9622641509433962
          },
          {
            "name": "Miguel",
            "popularity": 2.7222222222222223
          },
          {
            "name": "Juan",
            "popularity": 2.456692913385827
          },
          {
            "name": "Luis",
            "popularity": 2.364705882352941
          },
          {
            "name": "Woodrow",
            "popularity": 2.0576923076923075
          }
        ]
      }
    ]
  },
  {
    "state": "CA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Christina",
            "popularity": 1.3583333333333334
          },
          {
            "name": "Carmen",
            "popularity": 1.3473684210526315
          },
          {
            "name": "Yolanda",
            "popularity": 1.2571428571428571
          },
          {
            "name": "Teri",
            "popularity": 1.0597014925373134
          },
          {
            "name": "Maria",
            "popularity": 1.009493670886076
          },
          {
            "name": "Pat",
            "popularity": 0.9074074074074074
          },
          {
            "name": "Cecilia",
            "popularity": 0.8771929824561403
          },
          {
            "name": "Leslie",
            "popularity": 0.8484848484848485
          },
          {
            "name": "Julie",
            "popularity": 0.8373333333333334
          },
          {
            "name": "Victoria",
            "popularity": 0.8285714285714286
          },
          {
            "name": "Monica",
            "popularity": 0.7798165137614679
          },
          {
            "name": "Ramona",
            "popularity": 0.7638888888888888
          },
          {
            "name": "Alicia",
            "popularity": 0.7272727272727273
          },
          {
            "name": "Lydia",
            "popularity": 0.7236842105263158
          },
          {
            "name": "Shannon",
            "popularity": 0.7176470588235294
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 2.327272727272727
          },
          {
            "name": "Ruben",
            "popularity": 2
          },
          {
            "name": "Carlos",
            "popularity": 1.4683544303797469
          },
          {
            "name": "Mario",
            "popularity": 1.2307692307692308
          },
          {
            "name": "Mike",
            "popularity": 1.1956521739130435
          },
          {
            "name": "Jason",
            "popularity": 1.0694444444444444
          },
          {
            "name": "Bob",
            "popularity": 1.0357142857142858
          },
          {
            "name": "Lance",
            "popularity": 0.9821428571428571
          },
          {
            "name": "Gilbert",
            "popularity": 0.967479674796748
          },
          {
            "name": "Jim",
            "popularity": 0.9651162790697675
          },
          {
            "name": "Dave",
            "popularity": 0.9104477611940298
          },
          {
            "name": "Ricardo",
            "popularity": 0.8727272727272727
          },
          {
            "name": "Jose",
            "popularity": 0.8599033816425121
          },
          {
            "name": "Eric",
            "popularity": 0.8290322580645161
          },
          {
            "name": "Chris",
            "popularity": 0.824
          }
        ]
      }
    ]
  },
  {
    "state": "CO",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 1.9615384615384615
          },
          {
            "name": "Shelly",
            "popularity": 1.3679245283018868
          },
          {
            "name": "Olive",
            "popularity": 1.2692307692307692
          },
          {
            "name": "Bernadette",
            "popularity": 1.2105263157894737
          },
          {
            "name": "Ramona",
            "popularity": 1.1944444444444444
          },
          {
            "name": "Becky",
            "popularity": 1.1009174311926606
          },
          {
            "name": "Nicole",
            "popularity": 1.0909090909090908
          },
          {
            "name": "Heather",
            "popularity": 1.0705882352941176
          },
          {
            "name": "Della",
            "popularity": 1.0526315789473684
          },
          {
            "name": "Heidi",
            "popularity": 1.0303030303030303
          },
          {
            "name": "Erma",
            "popularity": 1.0151515151515151
          },
          {
            "name": "Dianna",
            "popularity": 1.0147058823529411
          },
          {
            "name": "Karla",
            "popularity": 0.9682539682539683
          },
          {
            "name": "Kelli",
            "popularity": 0.9636363636363636
          },
          {
            "name": "Shannon",
            "popularity": 0.9176470588235294
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kent",
            "popularity": 1.943661971830986
          },
          {
            "name": "Manuel",
            "popularity": 1.6363636363636365
          },
          {
            "name": "Kirk",
            "popularity": 1.6056338028169015
          },
          {
            "name": "Woodrow",
            "popularity": 1.5576923076923077
          },
          {
            "name": "Gilbert",
            "popularity": 1.3739837398373984
          },
          {
            "name": "Kelly",
            "popularity": 1.3333333333333333
          },
          {
            "name": "Brett",
            "popularity": 1.2876712328767124
          },
          {
            "name": "Bob",
            "popularity": 1.2053571428571428
          },
          {
            "name": "Shawn",
            "popularity": 1.11864406779661
          },
          {
            "name": "Delbert",
            "popularity": 1.1090909090909091
          },
          {
            "name": "Rick",
            "popularity": 1.104
          },
          {
            "name": "Mike",
            "popularity": 1.0695652173913044
          },
          {
            "name": "Jason",
            "popularity": 1.0277777777777777
          },
          {
            "name": "Dave",
            "popularity": 1
          },
          {
            "name": "Joe",
            "popularity": 0.9848484848484849
          }
        ]
      }
    ]
  },
  {
    "state": "CT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Sophie",
            "popularity": 2.6557377049180326
          },
          {
            "name": "Doreen",
            "popularity": 2.646153846153846
          },
          {
            "name": "Claire",
            "popularity": 1.7721518987341771
          },
          {
            "name": "Lynn",
            "popularity": 1.663716814159292
          },
          {
            "name": "Gail",
            "popularity": 1.5643939393939394
          },
          {
            "name": "Antoinette",
            "popularity": 1.5128205128205128
          },
          {
            "name": "Kristen",
            "popularity": 1.509433962264151
          },
          {
            "name": "Maureen",
            "popularity": 1.4767441860465116
          },
          {
            "name": "Maryann",
            "popularity": 1.4605263157894737
          },
          {
            "name": "Laurie",
            "popularity": 1.4080717488789238
          },
          {
            "name": "Marion",
            "popularity": 1.3429951690821256
          },
          {
            "name": "Jennie",
            "popularity": 1.2577319587628866
          },
          {
            "name": "Heather",
            "popularity": 1.188235294117647
          },
          {
            "name": "Anne",
            "popularity": 1.1428571428571428
          },
          {
            "name": "Heidi",
            "popularity": 1.101010101010101
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Peter",
            "popularity": 2.448577680525164
          },
          {
            "name": "Nicholas",
            "popularity": 1.983739837398374
          },
          {
            "name": "Salvatore",
            "popularity": 1.9
          },
          {
            "name": "Jonathan",
            "popularity": 1.7372881355932204
          },
          {
            "name": "Angelo",
            "popularity": 1.6428571428571428
          },
          {
            "name": "Francis",
            "popularity": 1.4749163879598661
          },
          {
            "name": "Alexander",
            "popularity": 1.3529411764705883
          },
          {
            "name": "Vincent",
            "popularity": 1.269406392694064
          },
          {
            "name": "Marc",
            "popularity": 1.1714285714285715
          },
          {
            "name": "Sean",
            "popularity": 1.1680672268907564
          },
          {
            "name": "Frederick",
            "popularity": 1.1526104417670682
          },
          {
            "name": "Anthony",
            "popularity": 1.0221238938053097
          },
          {
            "name": "Louis",
            "popularity": 0.9655172413793104
          },
          {
            "name": "Joseph",
            "popularity": 0.9080841638981174
          },
          {
            "name": "Theodore",
            "popularity": 0.841025641025641
          }
        ]
      }
    ]
  },
  {
    "state": "DC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cassandra",
            "popularity": 2.0185185185185186
          },
          {
            "name": "Crystal",
            "popularity": 2.0172413793103448
          },
          {
            "name": "Yvette",
            "popularity": 1.8666666666666667
          },
          {
            "name": "Tonya",
            "popularity": 1.8333333333333333
          },
          {
            "name": "Tanya",
            "popularity": 1.71875
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.5593220338983051
          },
          {
            "name": "Leslie",
            "popularity": 1.4
          },
          {
            "name": "Jacqueline",
            "popularity": 1.3650793650793651
          },
          {
            "name": "Delores",
            "popularity": 1.3310810810810811
          },
          {
            "name": "Laverne",
            "popularity": 1.3272727272727274
          },
          {
            "name": "Renee",
            "popularity": 1.31875
          },
          {
            "name": "Vanessa",
            "popularity": 1.316326530612245
          },
          {
            "name": "Nicole",
            "popularity": 1.290909090909091
          },
          {
            "name": "Monica",
            "popularity": 1.2660550458715596
          },
          {
            "name": "Yvonne",
            "popularity": 1.2531645569620253
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Tyrone",
            "popularity": 5.2631578947368425
          },
          {
            "name": "Reginald",
            "popularity": 3.7848101265822787
          },
          {
            "name": "Derrick",
            "popularity": 2.626865671641791
          },
          {
            "name": "Maurice",
            "popularity": 1.9081632653061225
          },
          {
            "name": "Ricardo",
            "popularity": 1.7636363636363637
          },
          {
            "name": "Darryl",
            "popularity": 1.693069306930693
          },
          {
            "name": "Dwayne",
            "popularity": 1.6875
          },
          {
            "name": "Derek",
            "popularity": 1.6851851851851851
          },
          {
            "name": "Nathaniel",
            "popularity": 1.4166666666666667
          },
          {
            "name": "Jonathan",
            "popularity": 1.3305084745762712
          },
          {
            "name": "Sean",
            "popularity": 1.2605042016806722
          },
          {
            "name": "Eric",
            "popularity": 1.2193548387096773
          },
          {
            "name": "Clifton",
            "popularity": 1.1666666666666667
          },
          {
            "name": "Bernard",
            "popularity": 1.0934579439252337
          },
          {
            "name": "Christopher",
            "popularity": 1
          }
        ]
      }
    ]
  },
  {
    "state": "DE",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Crystal",
            "popularity": 3.396551724137931
          },
          {
            "name": "Sophie",
            "popularity": 2.8688524590163933
          },
          {
            "name": "Mabel",
            "popularity": 2.5784313725490198
          },
          {
            "name": "Stella",
            "popularity": 2.3389830508474576
          },
          {
            "name": "Hilda",
            "popularity": 2.325301204819277
          },
          {
            "name": "Heather",
            "popularity": 2.1294117647058823
          },
          {
            "name": "Elsie",
            "popularity": 2.096969696969697
          },
          {
            "name": "Pearl",
            "popularity": 1.8387096774193548
          },
          {
            "name": "Nicole",
            "popularity": 1.8363636363636364
          },
          {
            "name": "Agnes",
            "popularity": 1.6979865771812082
          },
          {
            "name": "Holly",
            "popularity": 1.588785046728972
          },
          {
            "name": "Kristin",
            "popularity": 1.5820895522388059
          },
          {
            "name": "Dawn",
            "popularity": 1.5193798449612403
          },
          {
            "name": "Olive",
            "popularity": 1.5192307692307692
          },
          {
            "name": "Blanche",
            "popularity": 1.4487179487179487
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Woodrow",
            "popularity": 3.980769230769231
          },
          {
            "name": "Francis",
            "popularity": 2.3812709030100336
          },
          {
            "name": "Sean",
            "popularity": 1.4789915966386555
          },
          {
            "name": "Matthew",
            "popularity": 1.2567567567567568
          },
          {
            "name": "Tyrone",
            "popularity": 1.2456140350877194
          },
          {
            "name": "Harry",
            "popularity": 1.2115384615384615
          },
          {
            "name": "Roland",
            "popularity": 1.168421052631579
          },
          {
            "name": "Christopher",
            "popularity": 1.1674008810572687
          },
          {
            "name": "Franklin",
            "popularity": 1.139344262295082
          },
          {
            "name": "Dwayne",
            "popularity": 1.0625
          },
          {
            "name": "Horace",
            "popularity": 1.0483870967741935
          },
          {
            "name": "Willard",
            "popularity": 1.0470588235294118
          },
          {
            "name": "Wayne",
            "popularity": 1.0395778364116095
          },
          {
            "name": "Bryan",
            "popularity": 1.0341880341880343
          },
          {
            "name": "Jonathan",
            "popularity": 0.9067796610169492
          }
        ]
      }
    ]
  },
  {
    "state": "FL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cassandra",
            "popularity": 1.7037037037037037
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.5254237288135593
          },
          {
            "name": "Jacquelyn",
            "popularity": 1.323076923076923
          },
          {
            "name": "Rosa",
            "popularity": 1.0431654676258992
          },
          {
            "name": "Essie",
            "popularity": 0.9803921568627451
          },
          {
            "name": "Belinda",
            "popularity": 0.967032967032967
          },
          {
            "name": "Ernestine",
            "popularity": 0.9090909090909091
          },
          {
            "name": "Annie",
            "popularity": 0.8660436137071651
          },
          {
            "name": "Iris",
            "popularity": 0.8392857142857143
          },
          {
            "name": "Tina",
            "popularity": 0.8291666666666667
          },
          {
            "name": "Daisy",
            "popularity": 0.8285714285714286
          },
          {
            "name": "Johnnie",
            "popularity": 0.8243243243243243
          },
          {
            "name": "Angela",
            "popularity": 0.8207547169811321
          },
          {
            "name": "Willie",
            "popularity": 0.7715736040609137
          },
          {
            "name": "Inez",
            "popularity": 0.7428571428571429
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nathaniel",
            "popularity": 2.236111111111111
          },
          {
            "name": "Freddie",
            "popularity": 1.7435897435897436
          },
          {
            "name": "Willie",
            "popularity": 1.7160751565762005
          },
          {
            "name": "Johnnie",
            "popularity": 1.4375
          },
          {
            "name": "Reginald",
            "popularity": 1.3670886075949367
          },
          {
            "name": "Roosevelt",
            "popularity": 1.2352941176470589
          },
          {
            "name": "Horace",
            "popularity": 1.1774193548387097
          },
          {
            "name": "Eddie",
            "popularity": 1.0964467005076142
          },
          {
            "name": "Charlie",
            "popularity": 0.9020979020979021
          },
          {
            "name": "Derrick",
            "popularity": 0.8955223880597015
          },
          {
            "name": "Jimmie",
            "popularity": 0.8449612403100775
          },
          {
            "name": "Johnny",
            "popularity": 0.843065693430657
          },
          {
            "name": "Dwayne",
            "popularity": 0.765625
          },
          {
            "name": "Tyrone",
            "popularity": 0.7543859649122807
          },
          {
            "name": "Earnest",
            "popularity": 0.75
          }
        ]
      }
    ]
  },
  {
    "state": "GA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 3.9968847352024923
          },
          {
            "name": "Mattie",
            "popularity": 3.762962962962963
          },
          {
            "name": "Willie",
            "popularity": 3.1776649746192893
          },
          {
            "name": "Essie",
            "popularity": 3.0980392156862746
          },
          {
            "name": "Mamie",
            "popularity": 3.0273972602739727
          },
          {
            "name": "Johnnie",
            "popularity": 2.72972972972973
          },
          {
            "name": "Susie",
            "popularity": 2.4935064935064934
          },
          {
            "name": "Fannie",
            "popularity": 2.4444444444444446
          },
          {
            "name": "Lillie",
            "popularity": 2.4093959731543624
          },
          {
            "name": "Hattie",
            "popularity": 2.2823529411764705
          },
          {
            "name": "Katie",
            "popularity": 2.25
          },
          {
            "name": "Sara",
            "popularity": 2.183006535947712
          },
          {
            "name": "Rosa",
            "popularity": 2.172661870503597
          },
          {
            "name": "Daisy",
            "popularity": 2.0714285714285716
          },
          {
            "name": "Lucile",
            "popularity": 2.0677966101694913
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 4.636363636363637
          },
          {
            "name": "Willie",
            "popularity": 4.569937369519833
          },
          {
            "name": "Horace",
            "popularity": 3.0806451612903225
          },
          {
            "name": "Otis",
            "popularity": 2.7333333333333334
          },
          {
            "name": "Bennie",
            "popularity": 2.4827586206896552
          },
          {
            "name": "Johnnie",
            "popularity": 2.4375
          },
          {
            "name": "Eddie",
            "popularity": 2.3908629441624365
          },
          {
            "name": "Freddie",
            "popularity": 2.1153846153846154
          },
          {
            "name": "Nathaniel",
            "popularity": 2.0833333333333335
          },
          {
            "name": "Earnest",
            "popularity": 2.073529411764706
          },
          {
            "name": "Johnny",
            "popularity": 2.0437956204379564
          },
          {
            "name": "Marion",
            "popularity": 1.8125
          },
          {
            "name": "Roosevelt",
            "popularity": 1.803921568627451
          },
          {
            "name": "Hugh",
            "popularity": 1.7721518987341771
          },
          {
            "name": "Hubert",
            "popularity": 1.7692307692307692
          }
        ]
      }
    ]
  },
  {
    "state": "HI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kiyoko",
            "popularity": 6.7894736842105265
          },
          {
            "name": "Yoshiko",
            "popularity": 6.393258426966292
          },
          {
            "name": "Masako",
            "popularity": 5.983606557377049
          },
          {
            "name": "Fumiko",
            "popularity": 5.910714285714286
          },
          {
            "name": "Mitsue",
            "popularity": 5.867924528301887
          },
          {
            "name": "Shizue",
            "popularity": 4.775280898876405
          },
          {
            "name": "Roxanne",
            "popularity": 4.723076923076923
          },
          {
            "name": "Bernadette",
            "popularity": 4.578947368421052
          },
          {
            "name": "Yoshie",
            "popularity": 4.026666666666666
          },
          {
            "name": "Shizuko",
            "popularity": 3.9753086419753085
          },
          {
            "name": "Kikue",
            "popularity": 3.9655172413793105
          },
          {
            "name": "Iris",
            "popularity": 3.9107142857142856
          },
          {
            "name": "Mitsuko",
            "popularity": 3.8875
          },
          {
            "name": "Violet",
            "popularity": 3.6320754716981134
          },
          {
            "name": "Doreen",
            "popularity": 3.4153846153846152
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Toshio",
            "popularity": 7.901960784313726
          },
          {
            "name": "Yoshio",
            "popularity": 7.884615384615385
          },
          {
            "name": "Kiyoshi",
            "popularity": 6.985074626865671
          },
          {
            "name": "Kazuo",
            "popularity": 6.425925925925926
          },
          {
            "name": "Lance",
            "popularity": 6.089285714285714
          },
          {
            "name": "Minoru",
            "popularity": 5.980769230769231
          },
          {
            "name": "Derek",
            "popularity": 5.833333333333333
          },
          {
            "name": "Takeo",
            "popularity": 4.9411764705882355
          },
          {
            "name": "Jason",
            "popularity": 4.791666666666667
          },
          {
            "name": "Clayton",
            "popularity": 4.372881355932203
          },
          {
            "name": "Shigeo",
            "popularity": 4.311475409836065
          },
          {
            "name": "Nathan",
            "popularity": 3.967741935483871
          },
          {
            "name": "Guy",
            "popularity": 3.588235294117647
          },
          {
            "name": "Wendell",
            "popularity": 3.207547169811321
          },
          {
            "name": "Sean",
            "popularity": 3.092436974789916
          }
        ]
      }
    ]
  },
  {
    "state": "IA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Becky",
            "popularity": 1.926605504587156
          },
          {
            "name": "Karla",
            "popularity": 1.9206349206349207
          },
          {
            "name": "Maxine",
            "popularity": 1.8257575757575757
          },
          {
            "name": "Shelly",
            "popularity": 1.820754716981132
          },
          {
            "name": "Kristi",
            "popularity": 1.5769230769230769
          },
          {
            "name": "Julie",
            "popularity": 1.5226666666666666
          },
          {
            "name": "Jodi",
            "popularity": 1.4431818181818181
          },
          {
            "name": "Sheryl",
            "popularity": 1.403225806451613
          },
          {
            "name": "Marcella",
            "popularity": 1.3387096774193548
          },
          {
            "name": "Connie",
            "popularity": 1.3268608414239482
          },
          {
            "name": "Tami",
            "popularity": 1.3015873015873016
          },
          {
            "name": "Erma",
            "popularity": 1.2878787878787878
          },
          {
            "name": "Jody",
            "popularity": 1.2686567164179106
          },
          {
            "name": "Kristine",
            "popularity": 1.2272727272727273
          },
          {
            "name": "Roxanne",
            "popularity": 1.1076923076923078
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 3.761904761904762
          },
          {
            "name": "Duane",
            "popularity": 2.5080645161290325
          },
          {
            "name": "Kent",
            "popularity": 2.112676056338028
          },
          {
            "name": "Dean",
            "popularity": 2.0961538461538463
          },
          {
            "name": "Woodrow",
            "popularity": 1.7884615384615385
          },
          {
            "name": "Darin",
            "popularity": 1.7735849056603774
          },
          {
            "name": "Max",
            "popularity": 1.6849315068493151
          },
          {
            "name": "Bradley",
            "popularity": 1.6097560975609757
          },
          {
            "name": "Rick",
            "popularity": 1.584
          },
          {
            "name": "Delbert",
            "popularity": 1.5636363636363637
          },
          {
            "name": "Virgil",
            "popularity": 1.4871794871794872
          },
          {
            "name": "Dale",
            "popularity": 1.4707792207792207
          },
          {
            "name": "Lynn",
            "popularity": 1.45
          },
          {
            "name": "Jon",
            "popularity": 1.4413793103448276
          },
          {
            "name": "Rex",
            "popularity": 1.4385964912280702
          }
        ]
      }
    ]
  },
  {
    "state": "ID",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Olive",
            "popularity": 3.8076923076923075
          },
          {
            "name": "Karla",
            "popularity": 3.2063492063492065
          },
          {
            "name": "Heather",
            "popularity": 2.929411764705882
          },
          {
            "name": "Shannon",
            "popularity": 2.8117647058823527
          },
          {
            "name": "Shelley",
            "popularity": 2.730337078651685
          },
          {
            "name": "Kristi",
            "popularity": 2.5576923076923075
          },
          {
            "name": "Maxine",
            "popularity": 2.5303030303030303
          },
          {
            "name": "Becky",
            "popularity": 2.467889908256881
          },
          {
            "name": "Blanche",
            "popularity": 2.358974358974359
          },
          {
            "name": "Tamara",
            "popularity": 2.3423423423423424
          },
          {
            "name": "Robyn",
            "popularity": 2.169811320754717
          },
          {
            "name": "Tami",
            "popularity": 2.1587301587301586
          },
          {
            "name": "Jody",
            "popularity": 2.1194029850746268
          },
          {
            "name": "Opal",
            "popularity": 2.0927835051546393
          },
          {
            "name": "Shelly",
            "popularity": 2.018867924528302
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 5.944444444444445
          },
          {
            "name": "Brent",
            "popularity": 5.597560975609756
          },
          {
            "name": "Darin",
            "popularity": 5.452830188679245
          },
          {
            "name": "Lynn",
            "popularity": 5.2
          },
          {
            "name": "Woodrow",
            "popularity": 4.230769230769231
          },
          {
            "name": "Kim",
            "popularity": 3.8793103448275863
          },
          {
            "name": "Kent",
            "popularity": 3.7746478873239435
          },
          {
            "name": "Lyle",
            "popularity": 3.4126984126984126
          },
          {
            "name": "Rex",
            "popularity": 3.3684210526315788
          },
          {
            "name": "Max",
            "popularity": 2.9726027397260273
          },
          {
            "name": "Tracy",
            "popularity": 2.80327868852459
          },
          {
            "name": "Brett",
            "popularity": 2.493150684931507
          },
          {
            "name": "Brad",
            "popularity": 2.4615384615384617
          },
          {
            "name": "Delbert",
            "popularity": 2.4
          },
          {
            "name": "Rick",
            "popularity": 2.264
          }
        ]
      }
    ]
  },
  {
    "state": "IL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Laverne",
            "popularity": 1.2727272727272727
          },
          {
            "name": "Dolores",
            "popularity": 0.6666666666666666
          },
          {
            "name": "Rosemary",
            "popularity": 0.611764705882353
          },
          {
            "name": "Lorraine",
            "popularity": 0.6056910569105691
          },
          {
            "name": "Genevieve",
            "popularity": 0.6043956043956044
          },
          {
            "name": "Marcella",
            "popularity": 0.5806451612903226
          },
          {
            "name": "Pat",
            "popularity": 0.5555555555555556
          },
          {
            "name": "Marianne",
            "popularity": 0.5
          },
          {
            "name": "Marilyn",
            "popularity": 0.45879732739420936
          },
          {
            "name": "Judith",
            "popularity": 0.41637010676156583
          },
          {
            "name": "Loretta",
            "popularity": 0.38341968911917096
          },
          {
            "name": "Arlene",
            "popularity": 0.37037037037037035
          },
          {
            "name": "Eileen",
            "popularity": 0.35436893203883496
          },
          {
            "name": "Bernice",
            "popularity": 0.34782608695652173
          },
          {
            "name": "Kristine",
            "popularity": 0.32954545454545453
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jerome",
            "popularity": 0.6040268456375839
          },
          {
            "name": "Derrick",
            "popularity": 0.5373134328358209
          },
          {
            "name": "Tyrone",
            "popularity": 0.47368421052631576
          },
          {
            "name": "Maurice",
            "popularity": 0.42857142857142855
          },
          {
            "name": "Bradley",
            "popularity": 0.36585365853658536
          },
          {
            "name": "Tom",
            "popularity": 0.3355263157894737
          },
          {
            "name": "Lyle",
            "popularity": 0.3333333333333333
          },
          {
            "name": "Brad",
            "popularity": 0.2948717948717949
          },
          {
            "name": "Chester",
            "popularity": 0.2734375
          },
          {
            "name": "Patrick",
            "popularity": 0.26356589147286824
          },
          {
            "name": "Kurt",
            "popularity": 0.2558139534883721
          },
          {
            "name": "Lawrence",
            "popularity": 0.2521186440677966
          },
          {
            "name": "Bob",
            "popularity": 0.25
          },
          {
            "name": "Martin",
            "popularity": 0.24796747967479674
          },
          {
            "name": "Darryl",
            "popularity": 0.24752475247524752
          }
        ]
      }
    ]
  },
  {
    "state": "IN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tamara",
            "popularity": 1.3513513513513513
          },
          {
            "name": "Patty",
            "popularity": 1.1927710843373494
          },
          {
            "name": "Tina",
            "popularity": 1.1458333333333333
          },
          {
            "name": "Wilma",
            "popularity": 1.0172413793103448
          },
          {
            "name": "Penny",
            "popularity": 0.968503937007874
          },
          {
            "name": "Beth",
            "popularity": 0.959731543624161
          },
          {
            "name": "Marsha",
            "popularity": 0.952054794520548
          },
          {
            "name": "Olive",
            "popularity": 0.9423076923076923
          },
          {
            "name": "Sue",
            "popularity": 0.9367816091954023
          },
          {
            "name": "Lana",
            "popularity": 0.9215686274509803
          },
          {
            "name": "Dianna",
            "popularity": 0.9117647058823529
          },
          {
            "name": "Becky",
            "popularity": 0.8256880733944955
          },
          {
            "name": "Tonya",
            "popularity": 0.8222222222222222
          },
          {
            "name": "Marcia",
            "popularity": 0.8141025641025641
          },
          {
            "name": "Rebecca",
            "popularity": 0.7552083333333334
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Max",
            "popularity": 2.3698630136986303
          },
          {
            "name": "Rex",
            "popularity": 1.9298245614035088
          },
          {
            "name": "Kent",
            "popularity": 1.3380281690140845
          },
          {
            "name": "Rick",
            "popularity": 1.28
          },
          {
            "name": "Brent",
            "popularity": 1.1341463414634145
          },
          {
            "name": "Bradley",
            "popularity": 1.032520325203252
          },
          {
            "name": "Jeffery",
            "popularity": 0.9669421487603306
          },
          {
            "name": "Jeff",
            "popularity": 0.9536423841059603
          },
          {
            "name": "Tim",
            "popularity": 0.9459459459459459
          },
          {
            "name": "Wilbur",
            "popularity": 0.9047619047619048
          },
          {
            "name": "Darrin",
            "popularity": 0.8846153846153846
          },
          {
            "name": "Kerry",
            "popularity": 0.8793103448275862
          },
          {
            "name": "Darin",
            "popularity": 0.8679245283018868
          },
          {
            "name": "Garry",
            "popularity": 0.8333333333333334
          },
          {
            "name": "Terry",
            "popularity": 0.7539149888143176
          }
        ]
      }
    ]
  },
  {
    "state": "KS",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Karla",
            "popularity": 2.111111111111111
          },
          {
            "name": "Kristi",
            "popularity": 1.9230769230769231
          },
          {
            "name": "Maxine",
            "popularity": 1.8106060606060606
          },
          {
            "name": "Shelly",
            "popularity": 1.7924528301886793
          },
          {
            "name": "Wilma",
            "popularity": 1.7298850574712643
          },
          {
            "name": "Opal",
            "popularity": 1.556701030927835
          },
          {
            "name": "Deanna",
            "popularity": 1.4485981308411215
          },
          {
            "name": "Connie",
            "popularity": 1.4142394822006472
          },
          {
            "name": "Velma",
            "popularity": 1.392156862745098
          },
          {
            "name": "Lana",
            "popularity": 1.3725490196078431
          },
          {
            "name": "Lola",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Dana",
            "popularity": 1.2589285714285714
          },
          {
            "name": "Beulah",
            "popularity": 1.2325581395348837
          },
          {
            "name": "Dianna",
            "popularity": 1.2205882352941178
          },
          {
            "name": "Sheryl",
            "popularity": 1.2016129032258065
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Darin",
            "popularity": 3.5283018867924527
          },
          {
            "name": "Max",
            "popularity": 2.452054794520548
          },
          {
            "name": "Rex",
            "popularity": 2.280701754385965
          },
          {
            "name": "Delbert",
            "popularity": 2.2
          },
          {
            "name": "Kelly",
            "popularity": 2.1666666666666665
          },
          {
            "name": "Virgil",
            "popularity": 2.0128205128205128
          },
          {
            "name": "Lyle",
            "popularity": 1.9841269841269842
          },
          {
            "name": "Kent",
            "popularity": 1.8732394366197183
          },
          {
            "name": "Bradley",
            "popularity": 1.6341463414634145
          },
          {
            "name": "Brad",
            "popularity": 1.5256410256410255
          },
          {
            "name": "Bob",
            "popularity": 1.375
          },
          {
            "name": "Brent",
            "popularity": 1.329268292682927
          },
          {
            "name": "Duane",
            "popularity": 1.2338709677419355
          },
          {
            "name": "Everett",
            "popularity": 1.2307692307692308
          },
          {
            "name": "Marion",
            "popularity": 1.2125
          }
        ]
      }
    ]
  },
  {
    "state": "KY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Geneva",
            "popularity": 2.826530612244898
          },
          {
            "name": "Della",
            "popularity": 2.0701754385964914
          },
          {
            "name": "Opal",
            "popularity": 1.9690721649484537
          },
          {
            "name": "Shelia",
            "popularity": 1.7974683544303798
          },
          {
            "name": "Wilma",
            "popularity": 1.7586206896551724
          },
          {
            "name": "Beulah",
            "popularity": 1.6162790697674418
          },
          {
            "name": "Ruby",
            "popularity": 1.4720496894409938
          },
          {
            "name": "Wanda",
            "popularity": 1.4252199413489737
          },
          {
            "name": "Vickie",
            "popularity": 1.3571428571428572
          },
          {
            "name": "Ada",
            "popularity": 1.3478260869565217
          },
          {
            "name": "Alma",
            "popularity": 1.2733812949640289
          },
          {
            "name": "Nora",
            "popularity": 1.2
          },
          {
            "name": "Myrtle",
            "popularity": 1.1825396825396826
          },
          {
            "name": "Thelma",
            "popularity": 1.102661596958175
          },
          {
            "name": "Eula",
            "popularity": 1.096774193548387
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Donnie",
            "popularity": 3.343283582089552
          },
          {
            "name": "Jackie",
            "popularity": 2.25531914893617
          },
          {
            "name": "Wendell",
            "popularity": 1.7924528301886793
          },
          {
            "name": "Homer",
            "popularity": 1.7285714285714286
          },
          {
            "name": "Virgil",
            "popularity": 1.7179487179487178
          },
          {
            "name": "Cecil",
            "popularity": 1.6869565217391305
          },
          {
            "name": "Ronnie",
            "popularity": 1.6462264150943395
          },
          {
            "name": "Bobby",
            "popularity": 1.5963302752293578
          },
          {
            "name": "Billy",
            "popularity": 1.5960099750623442
          },
          {
            "name": "Hubert",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Garry",
            "popularity": 1.5
          },
          {
            "name": "Everett",
            "popularity": 1.4615384615384615
          },
          {
            "name": "Danny",
            "popularity": 1.3678571428571429
          },
          {
            "name": "Willard",
            "popularity": 1.3647058823529412
          },
          {
            "name": "Luther",
            "popularity": 1.328358208955224
          }
        ]
      }
    ]
  },
  {
    "state": "LA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Shelia",
            "popularity": 2.5822784810126582
          },
          {
            "name": "Irma",
            "popularity": 1.8243243243243243
          },
          {
            "name": "Eula",
            "popularity": 1.7580645161290323
          },
          {
            "name": "Rosie",
            "popularity": 1.7126436781609196
          },
          {
            "name": "Vanessa",
            "popularity": 1.663265306122449
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.61864406779661
          },
          {
            "name": "Mable",
            "popularity": 1.5806451612903225
          },
          {
            "name": "Lillie",
            "popularity": 1.429530201342282
          },
          {
            "name": "Hilda",
            "popularity": 1.3734939759036144
          },
          {
            "name": "Bobbie",
            "popularity": 1.31
          },
          {
            "name": "Glenda",
            "popularity": 1.3055555555555556
          },
          {
            "name": "Ella",
            "popularity": 1.3021582733812949
          },
          {
            "name": "Willie",
            "popularity": 1.284263959390863
          },
          {
            "name": "Cassandra",
            "popularity": 1.2407407407407407
          },
          {
            "name": "Paulette",
            "popularity": 1.2173913043478262
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Sidney",
            "popularity": 2.3846153846153846
          },
          {
            "name": "Clifton",
            "popularity": 2.25
          },
          {
            "name": "Freddie",
            "popularity": 2.230769230769231
          },
          {
            "name": "Alvin",
            "popularity": 2.0714285714285716
          },
          {
            "name": "Roosevelt",
            "popularity": 1.9803921568627452
          },
          {
            "name": "Jessie",
            "popularity": 1.9090909090909092
          },
          {
            "name": "Dwayne",
            "popularity": 1.71875
          },
          {
            "name": "Willie",
            "popularity": 1.6346555323590815
          },
          {
            "name": "Tyrone",
            "popularity": 1.4912280701754386
          },
          {
            "name": "Oliver",
            "popularity": 1.4901960784313726
          },
          {
            "name": "Kerry",
            "popularity": 1.4655172413793103
          },
          {
            "name": "Herman",
            "popularity": 1.4295774647887325
          },
          {
            "name": "Earnest",
            "popularity": 1.411764705882353
          },
          {
            "name": "Calvin",
            "popularity": 1.401360544217687
          },
          {
            "name": "Byron",
            "popularity": 1.3584905660377358
          }
        ]
      }
    ]
  },
  {
    "state": "MA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Claire",
            "popularity": 5.012658227848101
          },
          {
            "name": "Maureen",
            "popularity": 3.052325581395349
          },
          {
            "name": "Priscilla",
            "popularity": 2.2875
          },
          {
            "name": "Lynne",
            "popularity": 1.826086956521739
          },
          {
            "name": "Jeannette",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Anne",
            "popularity": 1.584717607973422
          },
          {
            "name": "Joanne",
            "popularity": 1.5236220472440944
          },
          {
            "name": "Doreen",
            "popularity": 1.476923076923077
          },
          {
            "name": "Eleanor",
            "popularity": 1.475177304964539
          },
          {
            "name": "Muriel",
            "popularity": 1.4179104477611941
          },
          {
            "name": "Sophie",
            "popularity": 1.3934426229508197
          },
          {
            "name": "Marion",
            "popularity": 1.2946859903381642
          },
          {
            "name": "Eileen",
            "popularity": 1.2815533980582525
          },
          {
            "name": "Jeanne",
            "popularity": 1.2774869109947644
          },
          {
            "name": "Lorraine",
            "popularity": 1.2357723577235773
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Francis",
            "popularity": 2.842809364548495
          },
          {
            "name": "Peter",
            "popularity": 2.0568927789934355
          },
          {
            "name": "Gerard",
            "popularity": 2.013888888888889
          },
          {
            "name": "Dana",
            "popularity": 1.8703703703703705
          },
          {
            "name": "Roland",
            "popularity": 1.6421052631578947
          },
          {
            "name": "Leo",
            "popularity": 1.5030674846625767
          },
          {
            "name": "Frederick",
            "popularity": 1.2811244979919678
          },
          {
            "name": "Stephen",
            "popularity": 1.2660550458715596
          },
          {
            "name": "Philip",
            "popularity": 1.186206896551724
          },
          {
            "name": "Paul",
            "popularity": 1.179289026275116
          },
          {
            "name": "Jonathan",
            "popularity": 1.1440677966101696
          },
          {
            "name": "Alfred",
            "popularity": 1.0278884462151394
          },
          {
            "name": "Sean",
            "popularity": 0.9663865546218487
          },
          {
            "name": "Arthur",
            "popularity": 0.9026717557251909
          },
          {
            "name": "Joseph",
            "popularity": 0.8560354374307863
          }
        ]
      }
    ]
  },
  {
    "state": "MD",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Crystal",
            "popularity": 1.6379310344827587
          },
          {
            "name": "Hilda",
            "popularity": 1.3253012048192772
          },
          {
            "name": "Vanessa",
            "popularity": 1.3061224489795917
          },
          {
            "name": "Yvette",
            "popularity": 1.2166666666666666
          },
          {
            "name": "Robin",
            "popularity": 1.0163934426229508
          },
          {
            "name": "Rosalie",
            "popularity": 0.8873239436619719
          },
          {
            "name": "Darlene",
            "popularity": 0.8846153846153846
          },
          {
            "name": "Bernadette",
            "popularity": 0.8245614035087719
          },
          {
            "name": "Dawn",
            "popularity": 0.813953488372093
          },
          {
            "name": "Terry",
            "popularity": 0.803030303030303
          },
          {
            "name": "Catherine",
            "popularity": 0.8027923211169284
          },
          {
            "name": "Tracey",
            "popularity": 0.7606837606837606
          },
          {
            "name": "Regina",
            "popularity": 0.75
          },
          {
            "name": "Naomi",
            "popularity": 0.75
          },
          {
            "name": "Michele",
            "popularity": 0.7490774907749077
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Tyrone",
            "popularity": 2.0701754385964914
          },
          {
            "name": "Dwayne",
            "popularity": 1.484375
          },
          {
            "name": "Roland",
            "popularity": 1.2210526315789474
          },
          {
            "name": "Reginald",
            "popularity": 1.1265822784810127
          },
          {
            "name": "Clifton",
            "popularity": 1.1166666666666667
          },
          {
            "name": "Bernard",
            "popularity": 1.0700934579439252
          },
          {
            "name": "Maurice",
            "popularity": 0.9693877551020408
          },
          {
            "name": "Franklin",
            "popularity": 0.8688524590163934
          },
          {
            "name": "Melvin",
            "popularity": 0.8611111111111112
          },
          {
            "name": "Milton",
            "popularity": 0.859504132231405
          },
          {
            "name": "Vernon",
            "popularity": 0.8397435897435898
          },
          {
            "name": "Jerome",
            "popularity": 0.8322147651006712
          },
          {
            "name": "Harry",
            "popularity": 0.8028846153846154
          },
          {
            "name": "Nelson",
            "popularity": 0.7321428571428571
          },
          {
            "name": "Darrin",
            "popularity": 0.7307692307692307
          }
        ]
      }
    ]
  },
  {
    "state": "ME",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Priscilla",
            "popularity": 4.3
          },
          {
            "name": "Jeannette",
            "popularity": 3.6323529411764706
          },
          {
            "name": "Muriel",
            "popularity": 3.3134328358208953
          },
          {
            "name": "Olive",
            "popularity": 2.6538461538461537
          },
          {
            "name": "Claire",
            "popularity": 2.5063291139240507
          },
          {
            "name": "Constance",
            "popularity": 2.3051948051948052
          },
          {
            "name": "Pauline",
            "popularity": 2.2650602409638556
          },
          {
            "name": "Madeline",
            "popularity": 2.066666666666667
          },
          {
            "name": "Laurie",
            "popularity": 1.937219730941704
          },
          {
            "name": "Rachel",
            "popularity": 1.85
          },
          {
            "name": "Debora",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Kristen",
            "popularity": 1.6226415094339623
          },
          {
            "name": "Marguerite",
            "popularity": 1.6210526315789473
          },
          {
            "name": "Heidi",
            "popularity": 1.5757575757575757
          },
          {
            "name": "Tina",
            "popularity": 1.5291666666666666
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Dana",
            "popularity": 7.277777777777778
          },
          {
            "name": "Roland",
            "popularity": 6.515789473684211
          },
          {
            "name": "Woodrow",
            "popularity": 4.3076923076923075
          },
          {
            "name": "Gerard",
            "popularity": 3.7222222222222223
          },
          {
            "name": "Maurice",
            "popularity": 3.63265306122449
          },
          {
            "name": "Clayton",
            "popularity": 2.864406779661017
          },
          {
            "name": "Reginald",
            "popularity": 2.6202531645569622
          },
          {
            "name": "Everett",
            "popularity": 2.358974358974359
          },
          {
            "name": "Troy",
            "popularity": 2.140740740740741
          },
          {
            "name": "Philip",
            "popularity": 2.010344827586207
          },
          {
            "name": "Adam",
            "popularity": 1.962962962962963
          },
          {
            "name": "Normand",
            "popularity": 1.8518518518518519
          },
          {
            "name": "Marc",
            "popularity": 1.7142857142857142
          },
          {
            "name": "Leo",
            "popularity": 1.6932515337423313
          },
          {
            "name": "Shawn",
            "popularity": 1.61864406779661
          }
        ]
      }
    ]
  },
  {
    "state": "MI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Sally",
            "popularity": 0.76
          },
          {
            "name": "Dawn",
            "popularity": 0.7403100775193798
          },
          {
            "name": "Colleen",
            "popularity": 0.6524822695035462
          },
          {
            "name": "Sue",
            "popularity": 0.6264367816091954
          },
          {
            "name": "Julie",
            "popularity": 0.616
          },
          {
            "name": "Marcia",
            "popularity": 0.6025641025641025
          },
          {
            "name": "Kay",
            "popularity": 0.5785123966942148
          },
          {
            "name": "Genevieve",
            "popularity": 0.5604395604395604
          },
          {
            "name": "Kelly",
            "popularity": 0.5564738292011019
          },
          {
            "name": "Suzanne",
            "popularity": 0.5281385281385281
          },
          {
            "name": "Marlene",
            "popularity": 0.5128205128205128
          },
          {
            "name": "Michelle",
            "popularity": 0.4911591355599214
          },
          {
            "name": "Renee",
            "popularity": 0.4875
          },
          {
            "name": "Sheryl",
            "popularity": 0.47580645161290325
          },
          {
            "name": "Shelly",
            "popularity": 0.46226415094339623
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 1.064516129032258
          },
          {
            "name": "Gerald",
            "popularity": 0.9387755102040817
          },
          {
            "name": "Kim",
            "popularity": 0.8620689655172413
          },
          {
            "name": "Gordon",
            "popularity": 0.8554216867469879
          },
          {
            "name": "Dave",
            "popularity": 0.835820895522388
          },
          {
            "name": "Lyle",
            "popularity": 0.8253968253968254
          },
          {
            "name": "Rick",
            "popularity": 0.784
          },
          {
            "name": "Darrin",
            "popularity": 0.7307692307692307
          },
          {
            "name": "Dale",
            "popularity": 0.6915584415584416
          },
          {
            "name": "Fredrick",
            "popularity": 0.6730769230769231
          },
          {
            "name": "Kurt",
            "popularity": 0.6162790697674418
          },
          {
            "name": "Kirk",
            "popularity": 0.6056338028169014
          },
          {
            "name": "Douglas",
            "popularity": 0.5559772296015181
          },
          {
            "name": "Dennis",
            "popularity": 0.5336463223787168
          },
          {
            "name": "Tim",
            "popularity": 0.5135135135135135
          }
        ]
      }
    ]
  },
  {
    "state": "MN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Jodi",
            "popularity": 2.5454545454545454
          },
          {
            "name": "Jody",
            "popularity": 2.0597014925373136
          },
          {
            "name": "Marcella",
            "popularity": 2
          },
          {
            "name": "Kristin",
            "popularity": 1.8805970149253732
          },
          {
            "name": "Roxanne",
            "popularity": 1.8615384615384616
          },
          {
            "name": "Kristine",
            "popularity": 1.7159090909090908
          },
          {
            "name": "Kristi",
            "popularity": 1.7115384615384615
          },
          {
            "name": "Colleen",
            "popularity": 1.553191489361702
          },
          {
            "name": "Harriet",
            "popularity": 1.5416666666666667
          },
          {
            "name": "Julie",
            "popularity": 1.472
          },
          {
            "name": "Lorraine",
            "popularity": 1.4065040650406504
          },
          {
            "name": "Heidi",
            "popularity": 1.393939393939394
          },
          {
            "name": "Delores",
            "popularity": 1.3243243243243243
          },
          {
            "name": "Shelly",
            "popularity": 1.320754716981132
          },
          {
            "name": "Marlene",
            "popularity": 1.2564102564102564
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 3.0793650793650795
          },
          {
            "name": "Duane",
            "popularity": 2.9193548387096775
          },
          {
            "name": "Bradley",
            "popularity": 2.6747967479674797
          },
          {
            "name": "Jerome",
            "popularity": 1.9597315436241611
          },
          {
            "name": "Dean",
            "popularity": 1.955128205128205
          },
          {
            "name": "Jason",
            "popularity": 1.8888888888888888
          },
          {
            "name": "Darin",
            "popularity": 1.6415094339622642
          },
          {
            "name": "Gordon",
            "popularity": 1.6204819277108433
          },
          {
            "name": "Todd",
            "popularity": 1.5364963503649636
          },
          {
            "name": "Jon",
            "popularity": 1.4689655172413794
          },
          {
            "name": "Troy",
            "popularity": 1.4296296296296296
          },
          {
            "name": "Dale",
            "popularity": 1.3993506493506493
          },
          {
            "name": "Arnold",
            "popularity": 1.3660714285714286
          },
          {
            "name": "Allan",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Scott",
            "popularity": 1.2675521821631879
          }
        ]
      }
    ]
  },
  {
    "state": "MO",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Wilma",
            "popularity": 1.471264367816092
          },
          {
            "name": "Opal",
            "popularity": 1.1546391752577319
          },
          {
            "name": "Laverne",
            "popularity": 1.0727272727272728
          },
          {
            "name": "Velma",
            "popularity": 0.9313725490196079
          },
          {
            "name": "Marcella",
            "popularity": 0.8548387096774194
          },
          {
            "name": "Lana",
            "popularity": 0.8235294117647058
          },
          {
            "name": "Christy",
            "popularity": 0.803921568627451
          },
          {
            "name": "Beulah",
            "popularity": 0.7558139534883721
          },
          {
            "name": "Carla",
            "popularity": 0.7448275862068966
          },
          {
            "name": "Shelly",
            "popularity": 0.7358490566037735
          },
          {
            "name": "Glenda",
            "popularity": 0.7291666666666666
          },
          {
            "name": "Georgia",
            "popularity": 0.725925925925926
          },
          {
            "name": "Norma",
            "popularity": 0.717391304347826
          },
          {
            "name": "Erma",
            "popularity": 0.7121212121212122
          },
          {
            "name": "Marsha",
            "popularity": 0.6438356164383562
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Virgil",
            "popularity": 1.3974358974358974
          },
          {
            "name": "Darin",
            "popularity": 1.1132075471698113
          },
          {
            "name": "Bob",
            "popularity": 1.0446428571428572
          },
          {
            "name": "Jackie",
            "popularity": 1.0212765957446808
          },
          {
            "name": "Everett",
            "popularity": 0.9230769230769231
          },
          {
            "name": "Delbert",
            "popularity": 0.9090909090909091
          },
          {
            "name": "Bill",
            "popularity": 0.8465608465608465
          },
          {
            "name": "Elmer",
            "popularity": 0.803030303030303
          },
          {
            "name": "Garry",
            "popularity": 0.7
          },
          {
            "name": "Vernon",
            "popularity": 0.6858974358974359
          },
          {
            "name": "Lloyd",
            "popularity": 0.6763005780346821
          },
          {
            "name": "Floyd",
            "popularity": 0.6727272727272727
          },
          {
            "name": "Oliver",
            "popularity": 0.6470588235294118
          },
          {
            "name": "Billy",
            "popularity": 0.6408977556109726
          },
          {
            "name": "Marion",
            "popularity": 0.6
          }
        ]
      }
    ]
  },
  {
    "state": "MS",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rosie",
            "popularity": 8.402298850574713
          },
          {
            "name": "Annie",
            "popularity": 5.015576323987539
          },
          {
            "name": "Willie",
            "popularity": 4.903553299492386
          },
          {
            "name": "Bobbie",
            "popularity": 4.2
          },
          {
            "name": "Maggie",
            "popularity": 4.078125
          },
          {
            "name": "Mattie",
            "popularity": 4.051851851851852
          },
          {
            "name": "Katie",
            "popularity": 4.035714285714286
          },
          {
            "name": "Lillie",
            "popularity": 4
          },
          {
            "name": "Hattie",
            "popularity": 3.988235294117647
          },
          {
            "name": "Essie",
            "popularity": 3.9019607843137254
          },
          {
            "name": "Johnnie",
            "popularity": 3.824324324324324
          },
          {
            "name": "Lula",
            "popularity": 3.738095238095238
          },
          {
            "name": "Fannie",
            "popularity": 3.419753086419753
          },
          {
            "name": "Minnie",
            "popularity": 3.1755725190839694
          },
          {
            "name": "Jessie",
            "popularity": 3.0390625
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Willie",
            "popularity": 6.281837160751566
          },
          {
            "name": "Roosevelt",
            "popularity": 6.078431372549019
          },
          {
            "name": "Jessie",
            "popularity": 5.5353535353535355
          },
          {
            "name": "Johnnie",
            "popularity": 4.339285714285714
          },
          {
            "name": "Eddie",
            "popularity": 3.8629441624365484
          },
          {
            "name": "Earnest",
            "popularity": 3.7941176470588234
          },
          {
            "name": "Jimmie",
            "popularity": 3.744186046511628
          },
          {
            "name": "Charlie",
            "popularity": 3.734265734265734
          },
          {
            "name": "Bennie",
            "popularity": 3.5689655172413794
          },
          {
            "name": "Clifton",
            "popularity": 2.85
          },
          {
            "name": "Otis",
            "popularity": 2.8
          },
          {
            "name": "Luther",
            "popularity": 2.373134328358209
          },
          {
            "name": "Sam",
            "popularity": 2.349056603773585
          },
          {
            "name": "Freddie",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Johnny",
            "popularity": 1.9598540145985401
          }
        ]
      }
    ]
  },
  {
    "state": "MT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 2.6825396825396823
          },
          {
            "name": "Mabel",
            "popularity": 2.6666666666666665
          },
          {
            "name": "Pat",
            "popularity": 2.5925925925925926
          },
          {
            "name": "Jamie",
            "popularity": 2.5211267605633805
          },
          {
            "name": "Shelly",
            "popularity": 2.5
          },
          {
            "name": "Teri",
            "popularity": 2.417910447761194
          },
          {
            "name": "Olive",
            "popularity": 2.3846153846153846
          },
          {
            "name": "Karla",
            "popularity": 2.3015873015873014
          },
          {
            "name": "Kristi",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Patti",
            "popularity": 2.1194029850746268
          },
          {
            "name": "Genevieve",
            "popularity": 2.065934065934066
          },
          {
            "name": "Colleen",
            "popularity": 1.929078014184397
          },
          {
            "name": "Shannon",
            "popularity": 1.9058823529411764
          },
          {
            "name": "Shelley",
            "popularity": 1.898876404494382
          },
          {
            "name": "Marlene",
            "popularity": 1.7756410256410255
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 3
          },
          {
            "name": "Lyle",
            "popularity": 2.7142857142857144
          },
          {
            "name": "Shawn",
            "popularity": 2.406779661016949
          },
          {
            "name": "Woodrow",
            "popularity": 2.2884615384615383
          },
          {
            "name": "Brett",
            "popularity": 2.1232876712328768
          },
          {
            "name": "Jason",
            "popularity": 1.9722222222222223
          },
          {
            "name": "Brad",
            "popularity": 1.9615384615384615
          },
          {
            "name": "Darin",
            "popularity": 1.9245283018867925
          },
          {
            "name": "Duane",
            "popularity": 1.8870967741935485
          },
          {
            "name": "Darren",
            "popularity": 1.8144329896907216
          },
          {
            "name": "Kirk",
            "popularity": 1.7605633802816902
          },
          {
            "name": "Dan",
            "popularity": 1.7217391304347827
          },
          {
            "name": "Tim",
            "popularity": 1.6756756756756757
          },
          {
            "name": "Lance",
            "popularity": 1.625
          },
          {
            "name": "Rick",
            "popularity": 1.608
          }
        ]
      }
    ]
  },
  {
    "state": "NC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 3.015576323987539
          },
          {
            "name": "Maggie",
            "popularity": 2.3125
          },
          {
            "name": "Katie",
            "popularity": 2.142857142857143
          },
          {
            "name": "Hattie",
            "popularity": 2.1294117647058823
          },
          {
            "name": "Mamie",
            "popularity": 1.9726027397260273
          },
          {
            "name": "Sadie",
            "popularity": 1.8928571428571428
          },
          {
            "name": "Mable",
            "popularity": 1.7096774193548387
          },
          {
            "name": "Lillie",
            "popularity": 1.604026845637584
          },
          {
            "name": "Shelia",
            "popularity": 1.5569620253164558
          },
          {
            "name": "Rosa",
            "popularity": 1.5539568345323742
          },
          {
            "name": "Fannie",
            "popularity": 1.4691358024691359
          },
          {
            "name": "Hilda",
            "popularity": 1.4578313253012047
          },
          {
            "name": "Rachel",
            "popularity": 1.425
          },
          {
            "name": "Crystal",
            "popularity": 1.4137931034482758
          },
          {
            "name": "Daisy",
            "popularity": 1.4
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 2.7132867132867133
          },
          {
            "name": "Clifton",
            "popularity": 2.2
          },
          {
            "name": "Bobby",
            "popularity": 2.021406727828746
          },
          {
            "name": "Hubert",
            "popularity": 1.9692307692307693
          },
          {
            "name": "Luther",
            "popularity": 1.955223880597015
          },
          {
            "name": "Johnnie",
            "popularity": 1.6875
          },
          {
            "name": "Donnie",
            "popularity": 1.6865671641791045
          },
          {
            "name": "Horace",
            "popularity": 1.6451612903225807
          },
          {
            "name": "Clyde",
            "popularity": 1.423841059602649
          },
          {
            "name": "Claude",
            "popularity": 1.4175824175824177
          },
          {
            "name": "Willie",
            "popularity": 1.3736951983298538
          },
          {
            "name": "Johnny",
            "popularity": 1.3722627737226278
          },
          {
            "name": "Ricky",
            "popularity": 1.2862068965517242
          },
          {
            "name": "Jimmy",
            "popularity": 1.2581818181818183
          },
          {
            "name": "Marshall",
            "popularity": 1.1967213114754098
          }
        ]
      }
    ]
  },
  {
    "state": "ND",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 6.346153846153846
          },
          {
            "name": "Karla",
            "popularity": 5.428571428571429
          },
          {
            "name": "Violet",
            "popularity": 4.056603773584905
          },
          {
            "name": "Myrtle",
            "popularity": 3.6031746031746033
          },
          {
            "name": "Shelly",
            "popularity": 3.4716981132075473
          },
          {
            "name": "Viola",
            "popularity": 3.296875
          },
          {
            "name": "Roxanne",
            "popularity": 3.276923076923077
          },
          {
            "name": "Jodi",
            "popularity": 3.1363636363636362
          },
          {
            "name": "Marlene",
            "popularity": 3.1346153846153846
          },
          {
            "name": "Paulette",
            "popularity": 3.0434782608695654
          },
          {
            "name": "Olga",
            "popularity": 2.8529411764705883
          },
          {
            "name": "Hilda",
            "popularity": 2.8313253012048194
          },
          {
            "name": "Olive",
            "popularity": 2.6923076923076925
          },
          {
            "name": "Leona",
            "popularity": 2.641509433962264
          },
          {
            "name": "Delores",
            "popularity": 2.614864864864865
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 6.333333333333333
          },
          {
            "name": "Darin",
            "popularity": 6.132075471698113
          },
          {
            "name": "Troy",
            "popularity": 5.985185185185185
          },
          {
            "name": "Duane",
            "popularity": 5.838709677419355
          },
          {
            "name": "Kelly",
            "popularity": 3.611111111111111
          },
          {
            "name": "Brent",
            "popularity": 3.3048780487804876
          },
          {
            "name": "Darren",
            "popularity": 3.2061855670103094
          },
          {
            "name": "Bradley",
            "popularity": 3
          },
          {
            "name": "Lynn",
            "popularity": 2.966666666666667
          },
          {
            "name": "Jason",
            "popularity": 2.8194444444444446
          },
          {
            "name": "Arnold",
            "popularity": 2.5535714285714284
          },
          {
            "name": "Gordon",
            "popularity": 2.5301204819277108
          },
          {
            "name": "Vernon",
            "popularity": 2.5256410256410255
          },
          {
            "name": "Kim",
            "popularity": 2.4655172413793105
          },
          {
            "name": "Dean",
            "popularity": 2.4358974358974357
          }
        ]
      }
    ]
  },
  {
    "state": "NE",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 3.1923076923076925
          },
          {
            "name": "Opal",
            "popularity": 2.7422680412371134
          },
          {
            "name": "Erma",
            "popularity": 2.196969696969697
          },
          {
            "name": "Maxine",
            "popularity": 2.022727272727273
          },
          {
            "name": "Shelly",
            "popularity": 1.9339622641509433
          },
          {
            "name": "Jody",
            "popularity": 1.5223880597014925
          },
          {
            "name": "Tami",
            "popularity": 1.492063492063492
          },
          {
            "name": "Jodi",
            "popularity": 1.4090909090909092
          },
          {
            "name": "Julie",
            "popularity": 1.408
          },
          {
            "name": "Olive",
            "popularity": 1.4038461538461537
          },
          {
            "name": "Leona",
            "popularity": 1.3773584905660377
          },
          {
            "name": "Wilma",
            "popularity": 1.3563218390804597
          },
          {
            "name": "Kay",
            "popularity": 1.3057851239669422
          },
          {
            "name": "Deanna",
            "popularity": 1.2429906542056075
          },
          {
            "name": "Christy",
            "popularity": 1.2352941176470589
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 4.507936507936508
          },
          {
            "name": "Duane",
            "popularity": 2.4596774193548385
          },
          {
            "name": "Darin",
            "popularity": 2.3773584905660377
          },
          {
            "name": "Kent",
            "popularity": 2.140845070422535
          },
          {
            "name": "Dean",
            "popularity": 1.814102564102564
          },
          {
            "name": "Dale",
            "popularity": 1.8051948051948052
          },
          {
            "name": "Bradley",
            "popularity": 1.8048780487804879
          },
          {
            "name": "Delbert",
            "popularity": 1.709090909090909
          },
          {
            "name": "Rex",
            "popularity": 1.6491228070175439
          },
          {
            "name": "Virgil",
            "popularity": 1.6282051282051282
          },
          {
            "name": "Troy",
            "popularity": 1.6074074074074074
          },
          {
            "name": "Lynn",
            "popularity": 1.55
          },
          {
            "name": "Kirk",
            "popularity": 1.4929577464788732
          },
          {
            "name": "Rick",
            "popularity": 1.408
          },
          {
            "name": "Kelly",
            "popularity": 1.4027777777777777
          }
        ]
      }
    ]
  },
  {
    "state": "NH",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristen",
            "popularity": 6.69811320754717
          },
          {
            "name": "Claire",
            "popularity": 6.2025316455696204
          },
          {
            "name": "Jeannette",
            "popularity": 4.911764705882353
          },
          {
            "name": "Priscilla",
            "popularity": 4.8625
          },
          {
            "name": "Heidi",
            "popularity": 3.888888888888889
          },
          {
            "name": "Blanche",
            "popularity": 3.8076923076923075
          },
          {
            "name": "Muriel",
            "popularity": 3.611940298507463
          },
          {
            "name": "Olive",
            "popularity": 3.3846153846153846
          },
          {
            "name": "Pauline",
            "popularity": 3.3132530120481927
          },
          {
            "name": "Nicole",
            "popularity": 2.7454545454545456
          },
          {
            "name": "Kristin",
            "popularity": 2.5970149253731343
          },
          {
            "name": "Sophie",
            "popularity": 2.5081967213114753
          },
          {
            "name": "Stella",
            "popularity": 2.4915254237288136
          },
          {
            "name": "Lorraine",
            "popularity": 2.1747967479674797
          },
          {
            "name": "Gertrude",
            "popularity": 2.1547619047619047
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Roland",
            "popularity": 7.726315789473684
          },
          {
            "name": "Maurice",
            "popularity": 6.010204081632653
          },
          {
            "name": "Gerard",
            "popularity": 5.138888888888889
          },
          {
            "name": "Dana",
            "popularity": 4.425925925925926
          },
          {
            "name": "Marc",
            "popularity": 3.1809523809523808
          },
          {
            "name": "Leo",
            "popularity": 2.687116564417178
          },
          {
            "name": "Normand",
            "popularity": 2.308641975308642
          },
          {
            "name": "Shawn",
            "popularity": 2.152542372881356
          },
          {
            "name": "Jonathan",
            "popularity": 2.135593220338983
          },
          {
            "name": "Peter",
            "popularity": 1.9781181619256019
          },
          {
            "name": "Norman",
            "popularity": 1.9540636042402826
          },
          {
            "name": "Roger",
            "popularity": 1.827659574468085
          },
          {
            "name": "Jason",
            "popularity": 1.6111111111111112
          },
          {
            "name": "Bruce",
            "popularity": 1.4939759036144578
          },
          {
            "name": "Scott",
            "popularity": 1.3453510436432639
          }
        ]
      }
    ]
  },
  {
    "state": "NJ",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maryann",
            "popularity": 2.289473684210526
          },
          {
            "name": "Claire",
            "popularity": 1.8734177215189873
          },
          {
            "name": "Eileen",
            "popularity": 1.5776699029126213
          },
          {
            "name": "Antoinette",
            "popularity": 1.5256410256410255
          },
          {
            "name": "Angelina",
            "popularity": 1.4615384615384615
          },
          {
            "name": "Rosemarie",
            "popularity": 1.4179104477611941
          },
          {
            "name": "Madeline",
            "popularity": 1.28
          },
          {
            "name": "Maureen",
            "popularity": 1.2674418604651163
          },
          {
            "name": "Marianne",
            "popularity": 1.2142857142857142
          },
          {
            "name": "Michele",
            "popularity": 1.1476014760147601
          },
          {
            "name": "Doreen",
            "popularity": 1.1384615384615384
          },
          {
            "name": "Joan",
            "popularity": 1.0298507462686568
          },
          {
            "name": "Eleanor",
            "popularity": 0.9929078014184397
          },
          {
            "name": "Marion",
            "popularity": 0.9710144927536232
          },
          {
            "name": "Sophie",
            "popularity": 0.9672131147540983
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nicholas",
            "popularity": 2.1463414634146343
          },
          {
            "name": "Dominick",
            "popularity": 1.9607843137254901
          },
          {
            "name": "Angelo",
            "popularity": 1.9107142857142858
          },
          {
            "name": "Vincent",
            "popularity": 1.6712328767123288
          },
          {
            "name": "Peter",
            "popularity": 1.4923413566739605
          },
          {
            "name": "Alexander",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Salvatore",
            "popularity": 1.288888888888889
          },
          {
            "name": "Anthony",
            "popularity": 1.2300884955752212
          },
          {
            "name": "Gerard",
            "popularity": 1.1666666666666667
          },
          {
            "name": "Joseph",
            "popularity": 1.1472868217054264
          },
          {
            "name": "Frank",
            "popularity": 0.9502824858757062
          },
          {
            "name": "Louis",
            "popularity": 0.9310344827586207
          },
          {
            "name": "Frederick",
            "popularity": 0.8032128514056225
          },
          {
            "name": "Edward",
            "popularity": 0.7849117174959872
          },
          {
            "name": "Theodore",
            "popularity": 0.7846153846153846
          }
        ]
      }
    ]
  },
  {
    "state": "NM",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cecilia",
            "popularity": 6
          },
          {
            "name": "Ramona",
            "popularity": 4.694444444444445
          },
          {
            "name": "Carmen",
            "popularity": 4.421052631578948
          },
          {
            "name": "Bernadette",
            "popularity": 3.9649122807017543
          },
          {
            "name": "Maria",
            "popularity": 3.7816455696202533
          },
          {
            "name": "Lucy",
            "popularity": 3.595419847328244
          },
          {
            "name": "Priscilla",
            "popularity": 3.5625
          },
          {
            "name": "Flora",
            "popularity": 2.96875
          },
          {
            "name": "Yolanda",
            "popularity": 2.7714285714285714
          },
          {
            "name": "Dora",
            "popularity": 2.67032967032967
          },
          {
            "name": "Marcella",
            "popularity": 2.6451612903225805
          },
          {
            "name": "Lydia",
            "popularity": 2.4210526315789473
          },
          {
            "name": "Lupe",
            "popularity": 2.2222222222222223
          },
          {
            "name": "Stella",
            "popularity": 2.1610169491525424
          },
          {
            "name": "Rosie",
            "popularity": 2.1149425287356323
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 10.227272727272727
          },
          {
            "name": "Jose",
            "popularity": 7.42512077294686
          },
          {
            "name": "Antonio",
            "popularity": 5.476190476190476
          },
          {
            "name": "Gilbert",
            "popularity": 5.227642276422764
          },
          {
            "name": "Ruben",
            "popularity": 5.016393442622951
          },
          {
            "name": "Juan",
            "popularity": 4.84251968503937
          },
          {
            "name": "Carlos",
            "popularity": 4.2784810126582276
          },
          {
            "name": "Joe",
            "popularity": 3.8354978354978355
          },
          {
            "name": "Pedro",
            "popularity": 2.8870967741935485
          },
          {
            "name": "Alex",
            "popularity": 2.765625
          },
          {
            "name": "Luis",
            "popularity": 2.764705882352941
          },
          {
            "name": "Francisco",
            "popularity": 2.75
          },
          {
            "name": "Miguel",
            "popularity": 2.740740740740741
          },
          {
            "name": "Jesus",
            "popularity": 2.676470588235294
          },
          {
            "name": "Bennie",
            "popularity": 2.5172413793103448
          }
        ]
      }
    ]
  },
  {
    "state": "NV",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Olga",
            "popularity": 5.102941176470588
          },
          {
            "name": "Traci",
            "popularity": 4.338709677419355
          },
          {
            "name": "Shannon",
            "popularity": 4.2
          },
          {
            "name": "Stacey",
            "popularity": 4.148148148148148
          },
          {
            "name": "Pat",
            "popularity": 3.9814814814814814
          },
          {
            "name": "Toni",
            "popularity": 3.1648351648351647
          },
          {
            "name": "Natalie",
            "popularity": 3.15
          },
          {
            "name": "Teri",
            "popularity": 3.014925373134328
          },
          {
            "name": "Kelli",
            "popularity": 2.981818181818182
          },
          {
            "name": "Marguerite",
            "popularity": 2.9473684210526314
          },
          {
            "name": "Tina",
            "popularity": 2.8875
          },
          {
            "name": "Blanche",
            "popularity": 2.7948717948717947
          },
          {
            "name": "Tami",
            "popularity": 2.746031746031746
          },
          {
            "name": "Nicole",
            "popularity": 2.7454545454545456
          },
          {
            "name": "Leslie",
            "popularity": 2.672727272727273
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jason",
            "popularity": 4.333333333333333
          },
          {
            "name": "Shawn",
            "popularity": 4.177966101694915
          },
          {
            "name": "Troy",
            "popularity": 4.022222222222222
          },
          {
            "name": "Kelly",
            "popularity": 3.736111111111111
          },
          {
            "name": "Woodrow",
            "popularity": 3.6538461538461537
          },
          {
            "name": "Lance",
            "popularity": 2.982142857142857
          },
          {
            "name": "Darren",
            "popularity": 2.711340206185567
          },
          {
            "name": "Mike",
            "popularity": 2.526086956521739
          },
          {
            "name": "Brent",
            "popularity": 2
          },
          {
            "name": "Adam",
            "popularity": 2
          },
          {
            "name": "Aaron",
            "popularity": 1.9864864864864864
          },
          {
            "name": "Darin",
            "popularity": 1.9622641509433962
          },
          {
            "name": "Brett",
            "popularity": 1.9589041095890412
          },
          {
            "name": "Delbert",
            "popularity": 1.8909090909090909
          },
          {
            "name": "Tracy",
            "popularity": 1.639344262295082
          }
        ]
      }
    ]
  },
  {
    "state": "NY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Antoinette",
            "popularity": 1.7564102564102564
          },
          {
            "name": "Eileen",
            "popularity": 1.674757281553398
          },
          {
            "name": "Madeline",
            "popularity": 1.6533333333333333
          },
          {
            "name": "Miriam",
            "popularity": 1.618421052631579
          },
          {
            "name": "Muriel",
            "popularity": 1.5671641791044777
          },
          {
            "name": "Angelina",
            "popularity": 1.5
          },
          {
            "name": "Rosemarie",
            "popularity": 1.462686567164179
          },
          {
            "name": "Maureen",
            "popularity": 1.3546511627906976
          },
          {
            "name": "Maryann",
            "popularity": 1.1578947368421053
          },
          {
            "name": "Marion",
            "popularity": 1
          },
          {
            "name": "Josephine",
            "popularity": 1
          },
          {
            "name": "Claire",
            "popularity": 0.9873417721518988
          },
          {
            "name": "Anne",
            "popularity": 0.9867109634551495
          },
          {
            "name": "Joan",
            "popularity": 0.9154228855721394
          },
          {
            "name": "Doreen",
            "popularity": 0.9076923076923077
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Salvatore",
            "popularity": 2.2222222222222223
          },
          {
            "name": "Angelo",
            "popularity": 2.0535714285714284
          },
          {
            "name": "Dominick",
            "popularity": 2.0392156862745097
          },
          {
            "name": "Vincent",
            "popularity": 1.9634703196347032
          },
          {
            "name": "Nicholas",
            "popularity": 1.7967479674796747
          },
          {
            "name": "Gerard",
            "popularity": 1.7916666666666667
          },
          {
            "name": "Peter",
            "popularity": 1.687089715536105
          },
          {
            "name": "Stuart",
            "popularity": 1.2096774193548387
          },
          {
            "name": "Anthony",
            "popularity": 1.1843657817109146
          },
          {
            "name": "Seymour",
            "popularity": 1.1111111111111112
          },
          {
            "name": "Alexander",
            "popularity": 1.035294117647059
          },
          {
            "name": "Martin",
            "popularity": 0.9146341463414634
          },
          {
            "name": "Neil",
            "popularity": 0.9078947368421053
          },
          {
            "name": "Philip",
            "popularity": 0.8896551724137931
          },
          {
            "name": "Louis",
            "popularity": 0.8488063660477454
          }
        ]
      }
    ]
  },
  {
    "state": "OH",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Beth",
            "popularity": 0.6778523489932886
          },
          {
            "name": "Patty",
            "popularity": 0.6506024096385542
          },
          {
            "name": "Sue",
            "popularity": 0.6379310344827587
          },
          {
            "name": "Amy",
            "popularity": 0.5906976744186047
          },
          {
            "name": "Marcella",
            "popularity": 0.5
          },
          {
            "name": "Dianna",
            "popularity": 0.45588235294117646
          },
          {
            "name": "Becky",
            "popularity": 0.44954128440366975
          },
          {
            "name": "Tonya",
            "popularity": 0.43333333333333335
          },
          {
            "name": "Kimberly",
            "popularity": 0.42205882352941176
          },
          {
            "name": "Rosemary",
            "popularity": 0.4117647058823529
          },
          {
            "name": "Marcia",
            "popularity": 0.3974358974358974
          },
          {
            "name": "Darla",
            "popularity": 0.39655172413793105
          },
          {
            "name": "Penny",
            "popularity": 0.3937007874015748
          },
          {
            "name": "Sandy",
            "popularity": 0.3924050632911392
          },
          {
            "name": "Marilyn",
            "popularity": 0.3897550111358575
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Rick",
            "popularity": 0.776
          },
          {
            "name": "Tim",
            "popularity": 0.7027027027027027
          },
          {
            "name": "Dave",
            "popularity": 0.6865671641791045
          },
          {
            "name": "Dale",
            "popularity": 0.5974025974025974
          },
          {
            "name": "Wilbur",
            "popularity": 0.5873015873015873
          },
          {
            "name": "Darrin",
            "popularity": 0.5192307692307693
          },
          {
            "name": "Jeffrey",
            "popularity": 0.4994152046783626
          },
          {
            "name": "Tom",
            "popularity": 0.4934210526315789
          },
          {
            "name": "Timothy",
            "popularity": 0.4813753581661891
          },
          {
            "name": "Jeffery",
            "popularity": 0.47520661157024796
          },
          {
            "name": "Jeff",
            "popularity": 0.423841059602649
          },
          {
            "name": "Ted",
            "popularity": 0.41025641025641024
          },
          {
            "name": "Karl",
            "popularity": 0.36904761904761907
          },
          {
            "name": "Carl",
            "popularity": 0.3557312252964427
          },
          {
            "name": "Dwight",
            "popularity": 0.35135135135135137
          }
        ]
      }
    ]
  },
  {
    "state": "OK",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Opal",
            "popularity": 4.134020618556701
          },
          {
            "name": "Billie",
            "popularity": 3.706422018348624
          },
          {
            "name": "Shelly",
            "popularity": 2.3962264150943398
          },
          {
            "name": "Velma",
            "popularity": 2.196078431372549
          },
          {
            "name": "Kristi",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Patsy",
            "popularity": 2.1538461538461537
          },
          {
            "name": "Darla",
            "popularity": 2.1379310344827585
          },
          {
            "name": "Wanda",
            "popularity": 2.1143695014662756
          },
          {
            "name": "Wilma",
            "popularity": 1.9310344827586208
          },
          {
            "name": "Geneva",
            "popularity": 1.7857142857142858
          },
          {
            "name": "Lola",
            "popularity": 1.7647058823529411
          },
          {
            "name": "Juanita",
            "popularity": 1.7043478260869565
          },
          {
            "name": "Erma",
            "popularity": 1.6818181818181819
          },
          {
            "name": "Kelli",
            "popularity": 1.6545454545454545
          },
          {
            "name": "Ruby",
            "popularity": 1.608695652173913
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Billy",
            "popularity": 3.13715710723192
          },
          {
            "name": "Jackie",
            "popularity": 2.7127659574468086
          },
          {
            "name": "Jimmie",
            "popularity": 2.5426356589147288
          },
          {
            "name": "Jimmy",
            "popularity": 2.367272727272727
          },
          {
            "name": "Tommy",
            "popularity": 2.2923976608187133
          },
          {
            "name": "Bill",
            "popularity": 2.2433862433862433
          },
          {
            "name": "Cecil",
            "popularity": 2.1478260869565218
          },
          {
            "name": "Bobby",
            "popularity": 2.110091743119266
          },
          {
            "name": "Delbert",
            "popularity": 2.036363636363636
          },
          {
            "name": "Bob",
            "popularity": 1.9642857142857142
          },
          {
            "name": "Virgil",
            "popularity": 1.8333333333333333
          },
          {
            "name": "Floyd",
            "popularity": 1.7515151515151515
          },
          {
            "name": "Rickey",
            "popularity": 1.6704545454545454
          },
          {
            "name": "Don",
            "popularity": 1.53475935828877
          },
          {
            "name": "Ronnie",
            "popularity": 1.471698113207547
          }
        ]
      }
    ]
  },
  {
    "state": "OR",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 3.0952380952380953
          },
          {
            "name": "Shannon",
            "popularity": 2.6470588235294117
          },
          {
            "name": "Shelley",
            "popularity": 1.9438202247191012
          },
          {
            "name": "Julie",
            "popularity": 1.912
          },
          {
            "name": "Kristi",
            "popularity": 1.9038461538461537
          },
          {
            "name": "Tamara",
            "popularity": 1.882882882882883
          },
          {
            "name": "Lucile",
            "popularity": 1.694915254237288
          },
          {
            "name": "Shelly",
            "popularity": 1.679245283018868
          },
          {
            "name": "Jan",
            "popularity": 1.5569620253164558
          },
          {
            "name": "Becky",
            "popularity": 1.4770642201834863
          },
          {
            "name": "Deanna",
            "popularity": 1.4485981308411215
          },
          {
            "name": "Kelli",
            "popularity": 1.4363636363636363
          },
          {
            "name": "Teri",
            "popularity": 1.4328358208955223
          },
          {
            "name": "Karla",
            "popularity": 1.4126984126984128
          },
          {
            "name": "Traci",
            "popularity": 1.3709677419354838
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Darin",
            "popularity": 2.981132075471698
          },
          {
            "name": "Woodrow",
            "popularity": 2.75
          },
          {
            "name": "Kelly",
            "popularity": 2.5694444444444446
          },
          {
            "name": "Rick",
            "popularity": 2.16
          },
          {
            "name": "Jason",
            "popularity": 2.0277777777777777
          },
          {
            "name": "Jim",
            "popularity": 1.8488372093023255
          },
          {
            "name": "Bob",
            "popularity": 1.7857142857142858
          },
          {
            "name": "Dan",
            "popularity": 1.7217391304347827
          },
          {
            "name": "Dave",
            "popularity": 1.6567164179104477
          },
          {
            "name": "Brad",
            "popularity": 1.6025641025641026
          },
          {
            "name": "Delbert",
            "popularity": 1.6
          },
          {
            "name": "Jeff",
            "popularity": 1.5827814569536425
          },
          {
            "name": "Mike",
            "popularity": 1.5608695652173914
          },
          {
            "name": "Lyle",
            "popularity": 1.5238095238095237
          },
          {
            "name": "Bradley",
            "popularity": 1.5121951219512195
          }
        ]
      }
    ]
  },
  {
    "state": "PA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Anna",
            "popularity": 1.387900355871886
          },
          {
            "name": "Dolores",
            "popularity": 1.1302681992337165
          },
          {
            "name": "Maryann",
            "popularity": 1.0526315789473684
          },
          {
            "name": "Eleanor",
            "popularity": 0.9787234042553191
          },
          {
            "name": "Miriam",
            "popularity": 0.9736842105263158
          },
          {
            "name": "Bernadette",
            "popularity": 0.9649122807017544
          },
          {
            "name": "Marian",
            "popularity": 0.7484276729559748
          },
          {
            "name": "Sophie",
            "popularity": 0.7377049180327869
          },
          {
            "name": "Rosemarie",
            "popularity": 0.7164179104477612
          },
          {
            "name": "Agnes",
            "popularity": 0.7114093959731543
          },
          {
            "name": "Helen",
            "popularity": 0.6921692169216922
          },
          {
            "name": "Florence",
            "popularity": 0.6865203761755486
          },
          {
            "name": "Stella",
            "popularity": 0.6271186440677966
          },
          {
            "name": "Joanne",
            "popularity": 0.6220472440944882
          },
          {
            "name": "Marianne",
            "popularity": 0.6
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Francis",
            "popularity": 1.394648829431438
          },
          {
            "name": "Harry",
            "popularity": 1.1466346153846154
          },
          {
            "name": "Joseph",
            "popularity": 1.012735326688815
          },
          {
            "name": "Nicholas",
            "popularity": 0.9186991869918699
          },
          {
            "name": "Barry",
            "popularity": 0.7129629629629629
          },
          {
            "name": "Bernard",
            "popularity": 0.6682242990654206
          },
          {
            "name": "Vincent",
            "popularity": 0.5981735159817352
          },
          {
            "name": "Edward",
            "popularity": 0.5947030497592295
          },
          {
            "name": "Andrew",
            "popularity": 0.5558659217877095
          },
          {
            "name": "Samuel",
            "popularity": 0.5517241379310345
          },
          {
            "name": "Theodore",
            "popularity": 0.5282051282051282
          },
          {
            "name": "Alexander",
            "popularity": 0.4823529411764706
          },
          {
            "name": "Albert",
            "popularity": 0.46331236897274636
          },
          {
            "name": "Stanley",
            "popularity": 0.4523076923076923
          },
          {
            "name": "Frank",
            "popularity": 0.4406779661016949
          }
        ]
      }
    ]
  },
  {
    "state": "RI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Claire",
            "popularity": 7.050632911392405
          },
          {
            "name": "Kristen",
            "popularity": 4.245283018867925
          },
          {
            "name": "Muriel",
            "popularity": 4.164179104477612
          },
          {
            "name": "Angelina",
            "popularity": 4
          },
          {
            "name": "Doreen",
            "popularity": 3.4
          },
          {
            "name": "Maureen",
            "popularity": 3.2209302325581395
          },
          {
            "name": "Jeannette",
            "popularity": 3.014705882352941
          },
          {
            "name": "Madeline",
            "popularity": 2.48
          },
          {
            "name": "Flora",
            "popularity": 2.3125
          },
          {
            "name": "Jennie",
            "popularity": 2.288659793814433
          },
          {
            "name": "Gertrude",
            "popularity": 2.2083333333333335
          },
          {
            "name": "Laurie",
            "popularity": 2.103139013452915
          },
          {
            "name": "Gail",
            "popularity": 2.0113636363636362
          },
          {
            "name": "Olga",
            "popularity": 1.9558823529411764
          },
          {
            "name": "Sophie",
            "popularity": 1.9508196721311475
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Roland",
            "popularity": 4.2631578947368425
          },
          {
            "name": "Gerard",
            "popularity": 3.1666666666666665
          },
          {
            "name": "Normand",
            "popularity": 2.9012345679012346
          },
          {
            "name": "Angelo",
            "popularity": 2.357142857142857
          },
          {
            "name": "Leo",
            "popularity": 2.3067484662576687
          },
          {
            "name": "Marc",
            "popularity": 2.276190476190476
          },
          {
            "name": "Alfred",
            "popularity": 1.9681274900398407
          },
          {
            "name": "Peter",
            "popularity": 1.8905908096280089
          },
          {
            "name": "Manuel",
            "popularity": 1.8181818181818181
          },
          {
            "name": "Raymond",
            "popularity": 1.7651715039577835
          },
          {
            "name": "Francis",
            "popularity": 1.6421404682274248
          },
          {
            "name": "Maurice",
            "popularity": 1.5510204081632653
          },
          {
            "name": "Vincent",
            "popularity": 1.5205479452054795
          },
          {
            "name": "Antonio",
            "popularity": 1.4761904761904763
          },
          {
            "name": "Anthony",
            "popularity": 1.3215339233038348
          }
        ]
      }
    ]
  },
  {
    "state": "SC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Hattie",
            "popularity": 4.223529411764706
          },
          {
            "name": "Rosa",
            "popularity": 4.093525179856115
          },
          {
            "name": "Maggie",
            "popularity": 3.984375
          },
          {
            "name": "Janie",
            "popularity": 3.948717948717949
          },
          {
            "name": "Annie",
            "popularity": 3.8161993769470404
          },
          {
            "name": "Mamie",
            "popularity": 3.7534246575342465
          },
          {
            "name": "Daisy",
            "popularity": 3.5428571428571427
          },
          {
            "name": "Lillie",
            "popularity": 3.5167785234899327
          },
          {
            "name": "Sadie",
            "popularity": 3.125
          },
          {
            "name": "Carrie",
            "popularity": 3.1142857142857143
          },
          {
            "name": "Essie",
            "popularity": 2.803921568627451
          },
          {
            "name": "Lula",
            "popularity": 2.6904761904761907
          },
          {
            "name": "Mattie",
            "popularity": 2.6296296296296298
          },
          {
            "name": "Willie",
            "popularity": 2.4060913705583755
          },
          {
            "name": "Jessie",
            "popularity": 2.265625
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Marion",
            "popularity": 4.875
          },
          {
            "name": "Nathaniel",
            "popularity": 4.375
          },
          {
            "name": "Willie",
            "popularity": 3.9478079331941545
          },
          {
            "name": "Roosevelt",
            "popularity": 3.3333333333333335
          },
          {
            "name": "Woodrow",
            "popularity": 2.826923076923077
          },
          {
            "name": "Luther",
            "popularity": 2.716417910447761
          },
          {
            "name": "Johnnie",
            "popularity": 2.5892857142857144
          },
          {
            "name": "Julius",
            "popularity": 2.5714285714285716
          },
          {
            "name": "Leroy",
            "popularity": 2.511627906976744
          },
          {
            "name": "Charlie",
            "popularity": 2.4055944055944054
          },
          {
            "name": "Bennie",
            "popularity": 2.3448275862068964
          },
          {
            "name": "Freddie",
            "popularity": 2.1538461538461537
          },
          {
            "name": "Otis",
            "popularity": 2.1333333333333333
          },
          {
            "name": "Horace",
            "popularity": 2.096774193548387
          },
          {
            "name": "Ben",
            "popularity": 1.7611940298507462
          }
        ]
      }
    ]
  },
  {
    "state": "SD",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 4.403846153846154
          },
          {
            "name": "Karla",
            "popularity": 3.9365079365079363
          },
          {
            "name": "Darla",
            "popularity": 3.3620689655172415
          },
          {
            "name": "Tamara",
            "popularity": 2.774774774774775
          },
          {
            "name": "Jody",
            "popularity": 2.611940298507463
          },
          {
            "name": "Violet",
            "popularity": 2.5660377358490565
          },
          {
            "name": "Mabel",
            "popularity": 2.5588235294117645
          },
          {
            "name": "Kay",
            "popularity": 2.520661157024793
          },
          {
            "name": "Delores",
            "popularity": 2.439189189189189
          },
          {
            "name": "Maxine",
            "popularity": 2.3484848484848486
          },
          {
            "name": "Verna",
            "popularity": 2.2837837837837838
          },
          {
            "name": "Viola",
            "popularity": 2.28125
          },
          {
            "name": "Olive",
            "popularity": 2.173076923076923
          },
          {
            "name": "Leona",
            "popularity": 2.169811320754717
          },
          {
            "name": "Lana",
            "popularity": 2.0784313725490198
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 7.285714285714286
          },
          {
            "name": "Darin",
            "popularity": 4.962264150943396
          },
          {
            "name": "Kelly",
            "popularity": 4.236111111111111
          },
          {
            "name": "Duane",
            "popularity": 4.088709677419355
          },
          {
            "name": "Bradley",
            "popularity": 3.2113821138211383
          },
          {
            "name": "Brad",
            "popularity": 2.628205128205128
          },
          {
            "name": "Troy",
            "popularity": 2.5555555555555554
          },
          {
            "name": "Todd",
            "popularity": 2.4306569343065694
          },
          {
            "name": "Delbert",
            "popularity": 2.3636363636363638
          },
          {
            "name": "Dean",
            "popularity": 2.301282051282051
          },
          {
            "name": "Dale",
            "popularity": 2.2305194805194803
          },
          {
            "name": "Elmer",
            "popularity": 1.9090909090909092
          },
          {
            "name": "Daryl",
            "popularity": 1.896551724137931
          },
          {
            "name": "Kim",
            "popularity": 1.8620689655172413
          },
          {
            "name": "Virgil",
            "popularity": 1.858974358974359
          }
        ]
      }
    ]
  },
  {
    "state": "TN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Shelia",
            "popularity": 2.7721518987341773
          },
          {
            "name": "Bobbie",
            "popularity": 1.82
          },
          {
            "name": "Wilma",
            "popularity": 1.5689655172413792
          },
          {
            "name": "Ruby",
            "popularity": 1.562111801242236
          },
          {
            "name": "Patsy",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Billie",
            "popularity": 1.4770642201834863
          },
          {
            "name": "Mattie",
            "popularity": 1.451851851851852
          },
          {
            "name": "Glenda",
            "popularity": 1.4027777777777777
          },
          {
            "name": "Geneva",
            "popularity": 1.3979591836734695
          },
          {
            "name": "Willie",
            "popularity": 1.3908629441624365
          },
          {
            "name": "Maggie",
            "popularity": 1.375
          },
          {
            "name": "Melissa",
            "popularity": 1.251082251082251
          },
          {
            "name": "Wanda",
            "popularity": 1.2287390029325513
          },
          {
            "name": "Tonya",
            "popularity": 1.211111111111111
          },
          {
            "name": "Johnnie",
            "popularity": 1.2027027027027026
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Billy",
            "popularity": 2.3840399002493764
          },
          {
            "name": "Jackie",
            "popularity": 2.265957446808511
          },
          {
            "name": "Bobby",
            "popularity": 2.217125382262997
          },
          {
            "name": "Rickey",
            "popularity": 2.0113636363636362
          },
          {
            "name": "Donnie",
            "popularity": 1.9701492537313432
          },
          {
            "name": "Jimmy",
            "popularity": 1.8945454545454545
          },
          {
            "name": "Ronnie",
            "popularity": 1.721698113207547
          },
          {
            "name": "Hubert",
            "popularity": 1.6
          },
          {
            "name": "Luther",
            "popularity": 1.5970149253731343
          },
          {
            "name": "Claude",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Tommy",
            "popularity": 1.5029239766081872
          },
          {
            "name": "Johnny",
            "popularity": 1.4817518248175183
          },
          {
            "name": "Ricky",
            "popularity": 1.4793103448275862
          },
          {
            "name": "Hugh",
            "popularity": 1.4050632911392404
          },
          {
            "name": "Charlie",
            "popularity": 1.2797202797202798
          }
        ]
      }
    ]
  },
  {
    "state": "TX",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maria",
            "popularity": 5.031645569620253
          },
          {
            "name": "Guadalupe",
            "popularity": 2.7444444444444445
          },
          {
            "name": "Yolanda",
            "popularity": 2.6952380952380954
          },
          {
            "name": "Billie",
            "popularity": 2.4954128440366974
          },
          {
            "name": "Irma",
            "popularity": 2.364864864864865
          },
          {
            "name": "Rosa",
            "popularity": 2.338129496402878
          },
          {
            "name": "Alicia",
            "popularity": 2.303030303030303
          },
          {
            "name": "Janie",
            "popularity": 2.1794871794871793
          },
          {
            "name": "Dora",
            "popularity": 1.835164835164835
          },
          {
            "name": "Olga",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Bobbie",
            "popularity": 1.6
          },
          {
            "name": "Patsy",
            "popularity": 1.5961538461538463
          },
          {
            "name": "Carmen",
            "popularity": 1.5894736842105264
          },
          {
            "name": "Lydia",
            "popularity": 1.5789473684210527
          },
          {
            "name": "Juanita",
            "popularity": 1.5521739130434782
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Juan",
            "popularity": 5.606299212598425
          },
          {
            "name": "Jose",
            "popularity": 4.903381642512077
          },
          {
            "name": "Ruben",
            "popularity": 4.508196721311475
          },
          {
            "name": "Manuel",
            "popularity": 4.036363636363636
          },
          {
            "name": "Jesus",
            "popularity": 3.764705882352941
          },
          {
            "name": "Pedro",
            "popularity": 3.6774193548387095
          },
          {
            "name": "Roberto",
            "popularity": 3.6176470588235294
          },
          {
            "name": "Ricardo",
            "popularity": 3.5272727272727273
          },
          {
            "name": "Raul",
            "popularity": 3.4927536231884058
          },
          {
            "name": "Carlos",
            "popularity": 3.3164556962025316
          },
          {
            "name": "Francisco",
            "popularity": 3.3088235294117645
          },
          {
            "name": "Antonio",
            "popularity": 3.2738095238095237
          },
          {
            "name": "Hector",
            "popularity": 2.5283018867924527
          },
          {
            "name": "Guadalupe",
            "popularity": 2.476923076923077
          },
          {
            "name": "Joe",
            "popularity": 2.1277056277056277
          }
        ]
      }
    ]
  },
  {
    "state": "UT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Robyn",
            "popularity": 5.60377358490566
          },
          {
            "name": "Sherrie",
            "popularity": 4.568627450980392
          },
          {
            "name": "Kristine",
            "popularity": 3.340909090909091
          },
          {
            "name": "Erma",
            "popularity": 3.1818181818181817
          },
          {
            "name": "Natalie",
            "popularity": 3.1666666666666665
          },
          {
            "name": "Becky",
            "popularity": 3.0275229357798166
          },
          {
            "name": "Colleen",
            "popularity": 3.0141843971631204
          },
          {
            "name": "Jan",
            "popularity": 2.949367088607595
          },
          {
            "name": "Julie",
            "popularity": 2.7466666666666666
          },
          {
            "name": "Jody",
            "popularity": 2.373134328358209
          },
          {
            "name": "Heidi",
            "popularity": 2.303030303030303
          },
          {
            "name": "Lucile",
            "popularity": 2.2203389830508473
          },
          {
            "name": "Leslie",
            "popularity": 2.175757575757576
          },
          {
            "name": "Teri",
            "popularity": 2.1044776119402986
          },
          {
            "name": "Shelly",
            "popularity": 2.0943396226415096
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Brent",
            "popularity": 10.182926829268293
          },
          {
            "name": "Lynn",
            "popularity": 9
          },
          {
            "name": "Kelly",
            "popularity": 7.111111111111111
          },
          {
            "name": "Kent",
            "popularity": 7.070422535211268
          },
          {
            "name": "Kim",
            "popularity": 5.931034482758621
          },
          {
            "name": "Darin",
            "popularity": 5.528301886792453
          },
          {
            "name": "Woodrow",
            "popularity": 5.365384615384615
          },
          {
            "name": "Brad",
            "popularity": 4.5
          },
          {
            "name": "Max",
            "popularity": 4.136986301369863
          },
          {
            "name": "Troy",
            "popularity": 4.029629629629629
          },
          {
            "name": "Rex",
            "popularity": 3.9298245614035086
          },
          {
            "name": "Tracy",
            "popularity": 3.2459016393442623
          },
          {
            "name": "Kerry",
            "popularity": 3.0344827586206895
          },
          {
            "name": "Don",
            "popularity": 2.978609625668449
          },
          {
            "name": "Jay",
            "popularity": 2.9545454545454546
          }
        ]
      }
    ]
  },
  {
    "state": "VA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Nannie",
            "popularity": 1.721311475409836
          },
          {
            "name": "Vanessa",
            "popularity": 1.510204081632653
          },
          {
            "name": "Rosa",
            "popularity": 1.330935251798561
          },
          {
            "name": "Shelia",
            "popularity": 1.3291139240506329
          },
          {
            "name": "Lucy",
            "popularity": 1.2290076335877862
          },
          {
            "name": "Fannie",
            "popularity": 1.0617283950617284
          },
          {
            "name": "Elsie",
            "popularity": 1.0545454545454545
          },
          {
            "name": "Susie",
            "popularity": 1.051948051948052
          },
          {
            "name": "Thelma",
            "popularity": 0.9695817490494296
          },
          {
            "name": "Hattie",
            "popularity": 0.9647058823529412
          },
          {
            "name": "Iris",
            "popularity": 0.9642857142857143
          },
          {
            "name": "Nellie",
            "popularity": 0.9618320610687023
          },
          {
            "name": "Angela",
            "popularity": 0.9276729559748428
          },
          {
            "name": "Virginia",
            "popularity": 0.9216216216216216
          },
          {
            "name": "Estelle",
            "popularity": 0.9090909090909091
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 1.7622377622377623
          },
          {
            "name": "Clifton",
            "popularity": 1.7
          },
          {
            "name": "Claude",
            "popularity": 1.6263736263736264
          },
          {
            "name": "Lewis",
            "popularity": 1.4722222222222223
          },
          {
            "name": "Luther",
            "popularity": 1.4029850746268657
          },
          {
            "name": "Calvin",
            "popularity": 1.2380952380952381
          },
          {
            "name": "Earnest",
            "popularity": 1.1911764705882353
          },
          {
            "name": "Otis",
            "popularity": 1.1833333333333333
          },
          {
            "name": "Marshall",
            "popularity": 1.1147540983606556
          },
          {
            "name": "Cecil",
            "popularity": 1.1130434782608696
          },
          {
            "name": "Nelson",
            "popularity": 1.0892857142857142
          },
          {
            "name": "Reginald",
            "popularity": 1.0506329113924051
          },
          {
            "name": "Franklin",
            "popularity": 1.0327868852459017
          },
          {
            "name": "Woodrow",
            "popularity": 1.0192307692307692
          },
          {
            "name": "Clarence",
            "popularity": 0.9739413680781759
          }
        ]
      }
    ]
  },
  {
    "state": "VT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Madeline",
            "popularity": 4.8
          },
          {
            "name": "Marion",
            "popularity": 4.1352657004830915
          },
          {
            "name": "Laurie",
            "popularity": 4.013452914798206
          },
          {
            "name": "Blanche",
            "popularity": 3.9358974358974357
          },
          {
            "name": "Claire",
            "popularity": 3.481012658227848
          },
          {
            "name": "Olive",
            "popularity": 3
          },
          {
            "name": "Priscilla",
            "popularity": 2.9125
          },
          {
            "name": "Heather",
            "popularity": 2.835294117647059
          },
          {
            "name": "Heidi",
            "popularity": 2.7373737373737375
          },
          {
            "name": "Penny",
            "popularity": 2.2755905511811023
          },
          {
            "name": "Marguerite",
            "popularity": 2.2736842105263158
          },
          {
            "name": "Pauline",
            "popularity": 2.2730923694779115
          },
          {
            "name": "Muriel",
            "popularity": 2.2686567164179103
          },
          {
            "name": "Tina",
            "popularity": 2.245833333333333
          },
          {
            "name": "Jeannette",
            "popularity": 2.161764705882353
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jason",
            "popularity": 4.138888888888889
          },
          {
            "name": "Reginald",
            "popularity": 3.6962025316455698
          },
          {
            "name": "Maurice",
            "popularity": 3.693877551020408
          },
          {
            "name": "Roland",
            "popularity": 3.3684210526315788
          },
          {
            "name": "Dana",
            "popularity": 3.314814814814815
          },
          {
            "name": "Wendell",
            "popularity": 2.7169811320754715
          },
          {
            "name": "Francis",
            "popularity": 2.6354515050167224
          },
          {
            "name": "Bernard",
            "popularity": 2.4953271028037385
          },
          {
            "name": "Gordon",
            "popularity": 2.4578313253012047
          },
          {
            "name": "Everett",
            "popularity": 2.2435897435897436
          },
          {
            "name": "Sean",
            "popularity": 2.1512605042016806
          },
          {
            "name": "Shawn",
            "popularity": 2.1440677966101696
          },
          {
            "name": "Clayton",
            "popularity": 2
          },
          {
            "name": "Kim",
            "popularity": 1.793103448275862
          },
          {
            "name": "Todd",
            "popularity": 1.7627737226277371
          }
        ]
      }
    ]
  },
  {
    "state": "WA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 2.9682539682539684
          },
          {
            "name": "Shannon",
            "popularity": 2.2
          },
          {
            "name": "Kristi",
            "popularity": 1.7884615384615385
          },
          {
            "name": "Heidi",
            "popularity": 1.707070707070707
          },
          {
            "name": "Olive",
            "popularity": 1.6730769230769231
          },
          {
            "name": "Shelley",
            "popularity": 1.6629213483146068
          },
          {
            "name": "Kelli",
            "popularity": 1.6545454545454545
          },
          {
            "name": "Colleen",
            "popularity": 1.6453900709219857
          },
          {
            "name": "Kristine",
            "popularity": 1.5
          },
          {
            "name": "Teri",
            "popularity": 1.3880597014925373
          },
          {
            "name": "Pat",
            "popularity": 1.2592592592592593
          },
          {
            "name": "Tamara",
            "popularity": 1.2342342342342343
          },
          {
            "name": "Gayle",
            "popularity": 1.1375
          },
          {
            "name": "Julie",
            "popularity": 1.1333333333333333
          },
          {
            "name": "Deanna",
            "popularity": 1.1214953271028036
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 2.236111111111111
          },
          {
            "name": "Woodrow",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Rick",
            "popularity": 2.04
          },
          {
            "name": "Dave",
            "popularity": 2
          },
          {
            "name": "Bob",
            "popularity": 1.9285714285714286
          },
          {
            "name": "Jim",
            "popularity": 1.8488372093023255
          },
          {
            "name": "Dan",
            "popularity": 1.7652173913043478
          },
          {
            "name": "Jason",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Jeff",
            "popularity": 1.6291390728476822
          },
          {
            "name": "Mike",
            "popularity": 1.5695652173913044
          },
          {
            "name": "Brad",
            "popularity": 1.3717948717948718
          },
          {
            "name": "Gordon",
            "popularity": 1.355421686746988
          },
          {
            "name": "Greg",
            "popularity": 1.3545454545454545
          },
          {
            "name": "Bill",
            "popularity": 1.2804232804232805
          },
          {
            "name": "Jon",
            "popularity": 1.2137931034482758
          }
        ]
      }
    ]
  },
  {
    "state": "WI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristine",
            "popularity": 2.8295454545454546
          },
          {
            "name": "Laverne",
            "popularity": 2.4545454545454546
          },
          {
            "name": "Jodi",
            "popularity": 1.7840909090909092
          },
          {
            "name": "Marcella",
            "popularity": 1.7258064516129032
          },
          {
            "name": "Kristin",
            "popularity": 1.328358208955224
          },
          {
            "name": "Lynn",
            "popularity": 1.3274336283185841
          },
          {
            "name": "Sophie",
            "popularity": 1.278688524590164
          },
          {
            "name": "Kay",
            "popularity": 1.2231404958677685
          },
          {
            "name": "Julie",
            "popularity": 1.1573333333333333
          },
          {
            "name": "Jody",
            "popularity": 1.1343283582089552
          },
          {
            "name": "Lorraine",
            "popularity": 1.0772357723577235
          },
          {
            "name": "Violet",
            "popularity": 1.0566037735849056
          },
          {
            "name": "Jill",
            "popularity": 1.0336538461538463
          },
          {
            "name": "Arlene",
            "popularity": 1.0123456790123457
          },
          {
            "name": "Audrey",
            "popularity": 0.946236559139785
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jerome",
            "popularity": 2.1073825503355703
          },
          {
            "name": "Lyle",
            "popularity": 2.0317460317460316
          },
          {
            "name": "Todd",
            "popularity": 1.8065693430656935
          },
          {
            "name": "Duane",
            "popularity": 1.6370967741935485
          },
          {
            "name": "Dean",
            "popularity": 1.3846153846153846
          },
          {
            "name": "Kurt",
            "popularity": 1.3837209302325582
          },
          {
            "name": "Gordon",
            "popularity": 1.216867469879518
          },
          {
            "name": "Dale",
            "popularity": 1.155844155844156
          },
          {
            "name": "Jon",
            "popularity": 1.1310344827586207
          },
          {
            "name": "Allan",
            "popularity": 1.1294117647058823
          },
          {
            "name": "Gerald",
            "popularity": 1.089795918367347
          },
          {
            "name": "Scott",
            "popularity": 1.077798861480076
          },
          {
            "name": "Arnold",
            "popularity": 0.9196428571428571
          },
          {
            "name": "Gregg",
            "popularity": 0.8823529411764706
          },
          {
            "name": "Jeffrey",
            "popularity": 0.8058479532163743
          }
        ]
      }
    ]
  },
  {
    "state": "WV",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Patty",
            "popularity": 2.2409638554216866
          },
          {
            "name": "Opal",
            "popularity": 1.9690721649484537
          },
          {
            "name": "Dianna",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Beulah",
            "popularity": 1.7790697674418605
          },
          {
            "name": "Violet",
            "popularity": 1.7735849056603774
          },
          {
            "name": "Mabel",
            "popularity": 1.6764705882352942
          },
          {
            "name": "Naomi",
            "popularity": 1.6071428571428572
          },
          {
            "name": "Nellie",
            "popularity": 1.4809160305343512
          },
          {
            "name": "Della",
            "popularity": 1.3859649122807018
          },
          {
            "name": "Tammy",
            "popularity": 1.3540489642184557
          },
          {
            "name": "Wilma",
            "popularity": 1.339080459770115
          },
          {
            "name": "Sherri",
            "popularity": 1.1507936507936507
          },
          {
            "name": "Nina",
            "popularity": 1.1375
          },
          {
            "name": "Thelma",
            "popularity": 1.1216730038022813
          },
          {
            "name": "Maxine",
            "popularity": 1.053030303030303
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jackie",
            "popularity": 2.606382978723404
          },
          {
            "name": "Delbert",
            "popularity": 2.2
          },
          {
            "name": "Homer",
            "popularity": 2.0428571428571427
          },
          {
            "name": "Franklin",
            "popularity": 2
          },
          {
            "name": "Woodrow",
            "popularity": 1.6538461538461537
          },
          {
            "name": "Cecil",
            "popularity": 1.6521739130434783
          },
          {
            "name": "Virgil",
            "popularity": 1.5897435897435896
          },
          {
            "name": "Willard",
            "popularity": 1.423529411764706
          },
          {
            "name": "Everett",
            "popularity": 1.2820512820512822
          },
          {
            "name": "Dana",
            "popularity": 1.2592592592592593
          },
          {
            "name": "Clyde",
            "popularity": 1.185430463576159
          },
          {
            "name": "Roger",
            "popularity": 1.1085106382978724
          },
          {
            "name": "Danny",
            "popularity": 1.0357142857142858
          },
          {
            "name": "Luther",
            "popularity": 1.0149253731343284
          },
          {
            "name": "Lewis",
            "popularity": 1.0069444444444444
          }
        ]
      }
    ]
  },
  {
    "state": "WY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Pat",
            "popularity": 3.074074074074074
          },
          {
            "name": "Shannon",
            "popularity": 2.8941176470588235
          },
          {
            "name": "Becky",
            "popularity": 2.7981651376146788
          },
          {
            "name": "Shelley",
            "popularity": 2.550561797752809
          },
          {
            "name": "Natalie",
            "popularity": 2.4833333333333334
          },
          {
            "name": "Jody",
            "popularity": 2.417910447761194
          },
          {
            "name": "Jamie",
            "popularity": 2.3661971830985915
          },
          {
            "name": "Stacy",
            "popularity": 2.313131313131313
          },
          {
            "name": "Agnes",
            "popularity": 2.2885906040268456
          },
          {
            "name": "Shelly",
            "popularity": 2.1037735849056602
          },
          {
            "name": "Violet",
            "popularity": 2.0943396226415096
          },
          {
            "name": "Olive",
            "popularity": 2
          },
          {
            "name": "Laurie",
            "popularity": 1.9820627802690582
          },
          {
            "name": "Hazel",
            "popularity": 1.974025974025974
          },
          {
            "name": "Opal",
            "popularity": 1.9278350515463918
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Troy",
            "popularity": 5.940740740740741
          },
          {
            "name": "Jason",
            "popularity": 4.430555555555555
          },
          {
            "name": "Kelly",
            "popularity": 3.75
          },
          {
            "name": "Kim",
            "popularity": 3.5517241379310347
          },
          {
            "name": "Brad",
            "popularity": 3.1923076923076925
          },
          {
            "name": "Kent",
            "popularity": 2.9014084507042255
          },
          {
            "name": "Woodrow",
            "popularity": 2.5961538461538463
          },
          {
            "name": "Brett",
            "popularity": 2.547945205479452
          },
          {
            "name": "Lance",
            "popularity": 2.5357142857142856
          },
          {
            "name": "Bob",
            "popularity": 2.2767857142857144
          },
          {
            "name": "Darin",
            "popularity": 2.0377358490566038
          },
          {
            "name": "Jim",
            "popularity": 1.9593023255813953
          },
          {
            "name": "Bill",
            "popularity": 1.693121693121693
          },
          {
            "name": "Darren",
            "popularity": 1.6701030927835052
          },
          {
            "name": "Bradley",
            "popularity": 1.6585365853658536
          }
        ]
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    CASE WHEN base.gender='M' THEN 'Male' ELSE 'Female' END as baby_gender__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN SUM(base.number) END as cohort_population__0,
    CASE WHEN group_set=1 THEN base.name END as name__1,
    CASE WHEN group_set=1 THEN SUM(base.number) END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_current` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,5,7
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    baby_gender__0 as baby_gender,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(name__1 as name, population__1 as population) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3,4
  ORDER BY 5 desc
)
, __stage2 AS (
  SELECT
    group_set,
    concat(by_name_0.name,'') as name__0,
    names.gender as gender__0,
    CASE WHEN group_set=0 THEN floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__0,
    CASE WHEN group_set=1 THEN names.state END as state__1,
    CASE WHEN group_set=1 THEN floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__1
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1) as names
  , UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  WHERE names.decade<1970
  GROUP BY 1,2,3,5
)
, __stage3 AS (
  SELECT
    name__0 as name,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN births_per_100k__0 END) as births_per_100k,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(state__1 as state, births_per_100k__1 as births_per_100k) END IGNORE NULLS  ORDER BY  births_per_100k__1 desc ) as by_state
  FROM __stage2
  GROUP BY 1,2
  ORDER BY 3 desc
)
, __stage4 AS (
  SELECT
    group_set,
    by_state_0.state as state__0,
    CASE WHEN group_set IN (1,2) THEN base.gender END as gender__1,
    CASE WHEN group_set=2 THEN base.name END as name__2,
    CASE WHEN group_set=2 THEN ((by_state_0.births_per_100k-base.births_per_100k))/base.births_per_100k END as popularity__2
  FROM `__stage3` as base
  , UNNEST(base.by_state) as by_state_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  WHERE base.births_per_100k>50
  GROUP BY 1,2,3,4,5
)
, __stage5 AS (
  SELECT 
    CASE WHEN group_set=2 THEN 1  ELSE group_set END as group_set,
    state__0 as state__0,
    CASE WHEN group_set IN (1,2) THEN gender__1 END as gender__1,
    ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(name__2 as name, popularity__2 as popularity) END IGNORE NULLS  ORDER BY  popularity__2 desc  LIMIT 15) as by_name__1
  FROM __stage4
  GROUP BY 1,2,3
)
SELECT
  state__0 as state,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(gender__1 as gender, by_name__1 as by_name) END IGNORE NULLS  ORDER BY  gender__1 asc ) as by_gender
FROM __stage5
GROUP BY 1
ORDER BY 1 asc